RE: Case-Insensitive search

---------- From: iftikhar_khan@mailcity.com[SMTP:iftikhar_khan@mailcity.com] >Can we make a case insensitive search in Informix? Example when I say >SELECT * FROM mytable WHERE mycol1 = "TEST">[...] Assuming you are using 7.30, then: SELECT * FROM MyTable WHERE UPPER(MyCol1) = "TEST"; Assuming you are using some other version, upgrade to 7.30 or look in the DejaNews archives or IIUG archives/FAQ for previous discussions of the subject. It is one of the monotonously recurring subjects of discussion in this news group, I regret to say. Yours, Jonathan Leffler (jleffler@visa.com) #include <bother.ms-exchange.h>