Re: Problem with upper/lowercase search

In article <360714FB.1C77D918@hotmail.com>, June Tong <june_t@hotmail.com> writes >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) Nee Naw! Nee Naw! Ok, I'll update it (once I've caught up with the backlog of ~300 news articles [only ~700 to go!] + 600 e-mail I've recived in the 3 weeks when I had no telephone!. >-- >june_t@hotmail.com >Lost in the wilds of Palo Alto, living on Mrs. Fields' chocolate chip >cookies > > -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care