One way I use are with the upper/lower functions, i.e.
Where upper(field) = upper(xxxx)

-----Original Message-----
From: Darren Nye
[mailto:oracledba-ezmlmshield-x8803743.[Email address protected]
Sent: Tuesday, February 27, 2007 8:05 AM
To: LazyDBA Discussion
Subject: case insensitive!

hello there, I really need to get oracle to perform case insensitive
searches,

I know that if you type

alter session set nls_comp=ansi;
alter session set nls_sort=binary_ci;

then it will perform case insensitive searches, but that's only for that
current session, is there a way to alter it for a particular user?

please help ive been stuck on this for hours!

thanks


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




This message (including any attachments) is confidential and intended solely for the use of the individual or entity to whom it is addressed, and is protected by law. If you are not the intended recipient, please delete the message (including any attachments) and notify the originator that you received the message in error. Any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. Any views expressed in this message are those of the individual sender, except where the sender specifies and with authority, states them to be the views of Vanguard Health Systems.

Oracle LazyDBA home page