Re: Are Informix deaf, dumb, and blind?

kerry@kcbbs.gen.nz (Kerry Sainsbury) wrote: This is a good point to bring up again and again. However, I would bet that the new Informix reply on this will be to write your own DataBlade to provide this functionality. It is really too bad that something as simple as this, and the case insensitive query, don't get addressed. Both of these have been open issues since at least the 5.x engine series so Informix had has plenty of time to include something as trivial as this. We all know it isn't ansi standard, but we don't care. Just give us a little help here. That's my $0.02 worth. BTW, I would guess your title is inappropriate as there don't appear to be any of those type of people watching the newsgroup. It really is too bad that J.L. isn't on the engine group. >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/