Skip to Content
Former Member
Mar 13, 2007 at 07:42 AM

Case insensitive search


In a database table i have a field which is can contain both upper and lower case chars..

I need to do a case insensitve pattern search.

for e,g. ig the column values are

Abc, ABC, ABc.....

and if the user enters abc he should be returned all rows that contain the

chars "abc" irrespective of their case.

Is there a method to tackle this using Ranges ?