Re: How to Disable Case sensivity for string compare ?

The question is a bit obscure. But try something like:         

        select * from tbl1 where lower(col1) = 'a';

This will test for 'a' and 'A' all the time.

-sooz

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

--

    Thanks.

• Susan

    Engineering System Administration
    Motorola Computer Group
    602-438-3765
    mailto:susan_wilson_at_phx.mcd.mot.com     http://www.eng.mcd.mot.com/ Received on Thu Nov 19 1998 - 18:33:34 CST