Re: Problem with upper/lowercase search

Art S. Kagel wrote: > Xavier Mertens wrote: > > > > Informix does make difference between lower/uppercase. > > How can I execute SQL request from an ESQL/C programm without case > > sensitivty? > > This one belongs in the FAQ if it is not there already (I actually > think that it is) four posts this month. Anyway if you have 7.3 you > can use the UPPER and LOWER SQL functions: > > select name from customers where UPPER(name) = "JOHN";> > If you do not have 7.3 you have to use brute force (there is an SPL > function in the IIUG archives, I think that June wrote it, but it is > not fast): Well, what can you expect when you have to loop through a string character by character, re-writing it as you go ;-) Now I'm going to start sounding like an advertising pitchman, but you REALLY should check out my Informix FAQ for this one. It's not simply a question of using an UPPER() function (which I believe IS covered in the "official" FAQ) -- there are big performance considerations, *even* if you have 7.3 and its built-in UPPER function. Go to http://www.geocities.com/SiliconValley/Bridge/4578/faq.html and look under "Generic SQL". June (waiting for the FAQ police to come and get me) -- june_t@hotmail.com Lost in the wilds of Palo Alto, living on Mrs. Fields' chocolate chip cookies