In article <01be13aa$8fb192e0$6d6464c3_at_kom>, Loy&Hutz <loyhutz_at_dinx.de>
writes
>
>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
>
Try
SELECT * FROM TBL1 WHERE LOWER(COL1) = 'a'
ORDER BY COL1
HTH
--
Tim Shute
Software Engineering Manager
NiSoft (UK) Limited
Unit 8, 31 Ballynahinch Road, Carryduff, BELFAST BT8 8EH
Internet: www.nisoft.co.uk
Received on Thu Nov 19 1998 - 08:19:24 CST
