Sql query to match Strings?

[Jessica James]

Hi..

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 friends help me..

Regards,
Jessica

[Jan Cumps]

Convert both the field value and the search string to the same case (e.g. uppercase):

select your_field from your_table where to_upper(your_other_field) like ....

Convert your search value to uppercase, and append the wildcard character % to it before passing it to the query (e.g. if the user entered pe, you must pass PE%).

Regards, Jan

[Jessica James]

Thanks a Lot ..
Its working fine