Hello,
I have an application in which I cannot change the code. There is a =
search function in the application on char or varchar2 table column. =
Search function is case sensitive as the author didn't use lower or =
upper functions in select statement.
My question is:
Does exist any trick, how to make this search function case insensitive =
only through database or user parameters/options? - I cannot imagine =
that, but ....=20
Oracle 8.1.7, Win2000
The reason why I am asking this question too is, that I was told, that =
MS SQL has such an option.
Thanks=20
Michal
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at
http://www.freelists.org/archives/oracle-l/
FAQ is at
http://www.freelists.org/help/fom-serve/cache/1.html
Received on Wed Apr 21 2004 - 04:14:28 CDT
