Skip to Content
Jan 31, 2005 at 07:07 AM

search * from t where a like b case-insensitive ?


I have a Database-field (CHAR60) that contains text with upper and lower case letters. In my application, the user can search for entries in the DB table using this field, which leads to an SQL statement like this:

SELECT * FROM table WHERE field LIKE pattern INTO...

My question:

If I search for "abc", i won't find entries with "aBc". Can I do a case-insensitive search with SELECT and LIKE?