Re: Case insenstive searches

Robert Arciere wrote: > > What is the best way to accomplish case-insentive searches using Informix > SQL??? > > Is it even possible??? > > Thanks This was a FAQ. You can still search for it in the usenet archives. The answer is, in short, no. However, it can, and has, been implemented by maintaining separate "search tables" for each char column you want to search for or a separate lower case column on the table. Not a very good solution, but maybe if you complain to informix about it, they might implement case insensitive searches someday. While you're at it, ask for multiple column subqueries, so that most correlated subqueries would be unneccessary: select a from table1 where b,c in (select b,c from table2) Any more things to put on the wish list? -- Sincerly, Doug Wilson(dougw@amgen.com) *** The opinions expressed here are my own and not neccessarily *** *** that of a rational human being . . . ************* *** Disclaimer: These are the opinions of the poster not Amgen Inc.***