Re: How to Disable Case sensivity for string compare ?

Hello

you're right Em, but with this (where upper(col1) =....) Oracle will not use an existing index on col1.......

Regards

Em Pradhan wrote:

> hi
> select * from case_checker upper(col1)=upper('kdjfalkfad');
> cheers..
>
> Loy&Hutz wrote:
>
> > I īd like to have the same behaviour like MS access.
> >
> > Is there a possibility / switch to dissable the case sensitivity for all
> > actions
> >
> > e.g.
> >
> > Select * from Tbl1 where Col1 = 'a'
> >
> > ->>>
> > Results with Col11 = 'A' or 'a'
> >
> > Perhaps with sort order ?
> >
> > Greetings Sven Kunze
Received on Thu Nov 19 1998 - 09:33:45 CST