Are Informix deaf, dumb, and blind?

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/