Originally posted by Bhiku Mhatre:
How to fire SQL query which searches a string in particular column in case insensitive manner with Oracle database. In mysql like '%searchString%' works fine. But oracle does return results from the same case.
PLEASE HELP...
Veena, is right however make sure you do UPPER() call on both sides of the SQL statement.
UPPER(col_name) like UPPER('%COL_NAME%');
Otherwise you are only converting to uppercase on the data retrieved and does not guarantee that the search string you are looking for is also upper cased.
Thanks,
John