Re: Case-insensitive matching in Informix ESQL/C

In article <818163058.17758@genesis.motiv.co.uk>, Staff user account <kcarter> wrote: >I would like to match a string against a character field, ignoring the >case of the characters. Is there some way I can do this with LIKE? Or >some other way? No, not practically, but the number of times I see this question asked is really starting to bug me so: INFORMIX: STICK THIS BLOODY FUNCTION INTO YOUR DATABASE, *PLEASE* It need not run at the speed of light, you don't have to make it multi-processing, dynamically scalable, or Internet-aware. I know nothing about the internals of database engines, but would suspect that you'd need not much more than a couple of calls to "toupper" and an "if" statement. It would seem that every other database company has managed this mighty feat without too much of a struggle :-) Grrrr. Love 'n kisses, Kerry S (who has spent the day trying to convince ViewPoint-Pro to talk to his database, and failed) ------------------------------------,------------------------------------------ Kerry Sainsbury, kerry@kcbbs.gen.nz | THE INFORMIX FAQ v2.4 Oct 95 Quanta Systems, Auckland | kcbbs.gen.nz:/informix/informix.[faq|apx] New Zealand. Work: +64 9 377-4473 | mathcs.emory.edu:/pub/informix/faq/ " " Home: +64 9 279-3571 | http://www.garpac.com/informix.html