am trying to perform a case sensitive serach of all columns in a table, so i did somthing like this
Select * From mytable Where col1 || '--' || col2 || '--' || etc like '%SomeValue%'
but it alwas return the same result for both upper case and lower case. if i do this
Select * From mytable Where col1 like '%SomeValue%' OR col1 like '%SomeValue%' etc
i get the desired result. The problems here is that i cannot use this second query as i have about 36 columns to search, and writing col1 like '%SomeValue%'
up to 36 times would be unecessary.
does anyone have any solution?