SQL Case Insensitive?

Am I right that the ADO SQL is case insensitive?
SELLECT * FROM MyTable WHERE City LIKE '%ne%'
finds all with NE, ne, Ne or nE anywhere in the field..

I used before LocalSQL (with BDE), and that one is case sensitive, but it 
allows also the use of the UPPER() function.
Just LIKE to know if this is correct.

Thanks,
+ Jan Pit +
Botswana 


.