Author: Tomas Rutkauskas
Does anyone know how to do a SELECT WHERE statement where it covers all cases.
Like, when a user types in 'new york' to search a city field, it finds all
occurrences of the string, like 'NEW YORK', 'New York', 'new york', 'NeW yOrk',
1 SELECT * FROM MyTable
2 WHERE UPPER(City) = 'NEW YORK'
Using UPPER makes it impossible to use an index which may hurt performance.