How to Disable Case sensivity for string compare ?

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 - 06:50:07 CST