Re: It's a dummy question...

Posted in 1997

Jay Allen — 15 Nov 1997 11:48:28 -0500 — source: Informix-list mailing list archive (1991-1998)

Hi Alexey, If you check out the Informix FAQ, you'll find the answer to your question. The answer is, no, Informix does not have UPPER, but you can replicate it using SPL - and many free implementations exist. The FAQ can be found off of http://www.iiug.org/ The UPPER question is answered in http://www.iiug.org/techinfo/faq/ifaq05.htm#5 -J- > > Hello, All! > Can you tell me, has Informix SQL "Upper" function. Or any other method to > make "order by" case unsensitive? > > In Oracle I made it like select * from tab order by UPPER(field). > > >