Make Oracle SQL LIKE query case insensitive?

See if this article helps: dba-oracle.com/t_case_insensitive_indexe... In versions older than 10gR2 it can't really be done and the usual approach, if you don't need accent-insensitive search, is to just UPPER() both the column and the search expression.

Maybe you can try using SELECT user_name FROM user_master WHERE upper(user_name) LIKE '%ME%.

– Konerak Mar 22 at 12:27 2 @sergionni you must upper case the search term as well! – Markus Winand Mar 22 at 12:28 1 @sergionni, well then why don't you use UPPER on the input parameter too? – Czechnology Mar 22 at 12:28.

Friendly reminder that some of the example searches will result in a full table scan even if there is an index on user_name.

You can always create a function based index to help that. – JOTN Mar 22 at 14:21.

Select user_name from my_table where nlssort(user_name, 'NLS_SORT = Latin_CI') = nlssort('%AbC%', 'NLS_SORT = Latin_CI').

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.