Re: string case insensitive comparisons with Oracle

Thanks for the response could prove very useful in the future.

In article <8e74uv$b18$1_at_nnrp1.deja.com>,   Larry <lculver_at_my-deja.com> wrote:
> No, string comparisions are very case sensitive.
>
> And yes if this comparision is in a join you can kiss your index scans
> good-bye. Assuming that this is the reason for your question AND
> forcing all the data in your DB to upper case is NOT an option then
> your best bet is to create a column(s) in the table(s) that does force
> the data to upper case and put an index on those column(s).
>
> Example:
>
> Table Employees
>
> First_Name Varchar2(20) (mixed case)
> Upper_First_Name Varchar2(20) (upper case) Put index on this
 column.
>
> Larry
>
> In article <8e737a$8uj$1_at_nnrp1.deja.com>,
> willmccormick_at_my-deja.com wrote:
> > Is there a way with Oracle to have string comparisions be cas
> > insensitive without using LOWER, UPPER or INDEX Functions?
> >
> > Sincerely,
> >
> > William McComick
> >
> > P.S. Please ignore this if my previous message went through. :]
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Apr 26 2000 - 00:00:00 CDT