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 ?