Re: Upper & Lower case

In article <HxSd1.2100$wG.897788@news.tpnet.pl>, Jarek B. <djbrenda@inet.com.pl> writes >I don't won't to differentiate in online upper and lower case. How to do it? > >f.e. >data >------ >mar >Mar >MAr >MAR >maR > >querry: >select data from table where data = "mar";>result: > >data >------ >mar > >I need result: > >data >------ >mar >Mar >MAr >MAR >maR > >Thanks, > >Jarek B. > > Added anotehr column data_uc in upper case and do select data from table where data_uc = "MAR" -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care