How to Disable Case sensivity for string compare ?

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 - 06:46:55 CST