Re: Uppercase conversion

Chengteh Lee wrote: > > Is there a way to do something in INFORMIX setup > to make a query case insensitive? > > So for a search query, > > Select A from tablename where A matches "ABC*"> > will return "Abc", "abc", "aBCD" ... > Unfortunately, nothing built-in to Informix, like a switch or anything. All solutions would have to be left to the developer. This is something that would have been a nice feature (a long time ago). The most common work-around is to convert the case before storing the data. (e.g., upshift). Then case is not an issue. However, recognizing this is not always ideal, you may have to step to plan B. If you have WWW access, check out the faq on IIUG's home site: http://www.iiug.org Tim P.S. If you can't get it, I can mail it to you.