RE: Are Informix deaf, dumb, and blind?

Thank you, Kerry, for brining this up (again)! Many of us are desperately waiting for an elegant, official Informix solution for this stupid little problem! Cheers. Ralph. ________________________________________________________________________ Never attribute to malice that which is adequately explained by stupidity. ____________________ ralph.halter@pac.panmail.com ________________________ ---------- ATTENTION INFORMIX PEOPLE WHO GIVE A DAMN: The following is *the* most frequently asked question. Are there *any* plans to do something about providing this functionality? We'd sure appreciate hearing about it! Exasperatedly, Kerry S In article <32430939.23BA@thomtech.com>, Ashi Chaturvedula <ashi@thomtech.com> wrote: >hi folks, > >I am new to the Informix World; Is there a SQL function in Informix SQL >that converts a varchar data to all uppercase ( similar to Oracle's >UPPER/INITCAPS function)? >For eg. > >select first_name,last_name >from user_information >where UPPER(first_name)=upper('Joe Blo');> >thanks in advance. > >ashi@thomtech.com -- ------------------------------------,------------------------------------------ Kerry Sainsbury, kerry@kcbbs.gen.nz | THE INFORMIX FAQ v2.5 June 96 Quanta Systems, Auckland | http://www.iiug.org/techinfo/faq/ New Zealand. Work: +64 9 377-4473 | ftp://ftp.iiug.org/pub/informix/faq Home: +64 9 279-3571 | ftp://kcbbs.gen.nz:/pub/informix/