Re: How to Disable Case sensivity for string compare ?

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 - 07:27:16 CST