When SELECTing, Oracle is already "case-sensitive". When using UPPER,
you're comparing regardless of case. But, I'm not sure exactly what you're
trying to accomplish. Could you post an example?

Thanks,
Jon Knight

-----Original Message-----
From: Benbart
[mailto:oracledba-ezmlmshield-x10487695.[Email address protected]
Sent: Sunday, May 29, 2005 2:30 AM
To: LazyDBA Discussion
Subject: UPPER function ..

Hi all,

How do I configure to be case insensitive so that I do not have to use the
UPPER function?



--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.322 / Virus Database: 267.2.0 - Release Date: 27/05/2005



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page