use the nls_sort parameters. There are lot of ones describe (ex: binary_ai) depend on your language...


----- Original Message -----
From: "Knight Jon " <oracledba-ezmlmshield-x76874968.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Subject: RE: UPPER function ..
Date: Sun, 29 May 2005 17:04:35 -0500

>
> 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
>
>
> --------
> 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



DEGAND XAVIER

DX SPRL

BRUSSELS, BELGIUM


Oracle LazyDBA home page