ODBC driver does not support the requested properties.
1176 common3
SELECT *,left(city,1) as init, replace(replace(countries.Country,' ',''),'&','') as flag FROM schools,countries WHERE countries.ID = schools.Country and schools.Country = 106 Group BY City ASC;