Re: Doing case-insensitive searches

Few years ago, I had similar problem with case-sensitive searches. What I had to do was save data in upper case and convert search string to upper case. For example: When a user enters search string in entry form, I take that string and convert it to upper case than use it in select command. Hope this helps. slee@gus.net At 11/19/98 05:03 PM +0200, Lisa Retief wrote: >We have just discovered that Informix will only do case-sensitive searches, >which is a huge problem for a project we are working on. It is possible to >do a match using syntax such as [A][a] etc, but then the table indexing is >of no use to us and such searches are far too expensive. Has anyone come >across a solution for this dilemma? Is there a way to set an Informix >database to be case-insensitive. > >I would appreciate any input. Please respond via email where posible. > >Thanks >Lisa > > > >