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', 
etc..

Answer:

1   SELECT * FROM MyTable
2   WHERE UPPER(City) = 'NEW YORK'


Using UPPER makes it impossible to use an index which may hurt performance.