Re: How to Disable Case sensivity for string compare ?

select * from tbl1 where upper(col1) = 'A';

In article <01be13aa$8fb192e0$6d6464c3_at_kom>, Loy&Hutz <loyhutz_at_dinx.de> 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:12:48 CST