Case insensitive search
Posted on 2001-07-25
I am working with SQL 2000 and have a search problem. In the past I used to be able to do a search with out worring about case, but the server here seems to be case sensitive.
A simple query like
select * from staff
Name LIKE 'g%'
will not return the name 'Graeme'. it wants a 'G'.
My Question is - how do I perform a case-insenitive search in my query?