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 ?