Okay. then the answer is simple. You can't.
Jim
"ARP" <sirapitt_at_hotmail.com> wrote in message
news:ud15hclrcho751_at_corp.supernews.com...
> Configuration Question:
>
> How does one go about setting an Oracle Server installation to be Case
> Insensitive for the comparison of literal strings via "WHERE" clauses in
SQL
> statements. As an example, I want to configure my server such that the
> clauses [where CITY = 'MEMPHIS'] and [where CITY = 'Memphis'] return the
> same result sets.
>
> The 9i documentation is not very expressive on this particular subject
(one
> of the few). I did find an NLS setting called NLS_COMP which can have
values
> of ANSI and BINARY where the latter is the default, but I need to know
> conclusively what the deal is here.
>
> BTW, I am fully aware of use of the UPPER() function in ANSI-compatible
SQL.
> That is besides the point for the purpose of this discussion.
>
> Thanks in advance.
>
>
Received on Wed May 01 2002 - 22:04:10 CDT
