Re: How to Disable Case sensivity for string compare ?

From: Jason Jay Weiland <archduke_at_uclink4.berkeley.edu>
Date: Wed, 04 Nov 1998 08:42:06 -0800
Message-ID: <364083DE.7A800273@uclink4.berkeley.edu>

Sven,

     You could try using the UPPER or LOWER charcter functions:

UPPER('Aaa') = 'AAA'
UPPER('aaa') = 'AAA'
UPPER('AAA') = 'AAA'

LOWER('Aaa') = 'aaa'

LOWER('aaa') = 'aaa'
LOWER('aaa') = 'aaa'

...so your query would be:

SELECT *
  FROM Tbl1
 WHERE LOWER(Col1) = 'a';

...and be warned: a query applying a function to the column will ignore any index you may have on that column. (i.e. don't use LOWER if you want to use an index on col1).

Jay!!!

Loy&Hutz wrote:

> Is there a possibility / switch to dissable the case sensitivity
>
> e.g.
> Select * from Tbl1 where Col1 = 'a'
>
> ->>>
> Results with Col11 = 'A' or 'a'
>
> Greetings Sven Kunze
Received on Wed Nov 04 1998 - 10:42:06 CST