match string using sql query...

My application is to get a search string from the user and return the records from the database which matches the search string..

I am using LIKE operator in the sql to get matching data..

But my problem is, the matching should be case insensitive..

For example, the data i required may be the Pen..

I have to get this value if i give any of the following possiblities as the search string..
p,pe,pen,PEN,Pen..

please help me with this..

-----------------------
suresh

Hi,

U can try following query:-

select pen_name from table_name where upper(pen_name) like '%PEN%';
or
select pen_name from table_name where lower(pen_name) like '%pen%';

Reeta

This will work :eek:

SELECT * FROM table_name WHERE Upper(column_name) LIKE Upper(search_string);

Thanks guys...That is working fine..

---------------------
suresh