Re: Case insensitive sorting

Posted in 1996

Kerry Sainsbury — Tue, 21 May 1996 20:11:04 +1200 — source: Informix-list mailing list archive (1991-1998)

In article <4ni41c$pg0@ns5-1.CC.Lehigh.EDU>, jaf0@Lehigh.EDU wrote: >Is there a way to get an Informix database to ignore case when sorting >(the ORDER BY clause in a SELECT statement). Is it possible to do this with >the NLS features? Succinctly: No. There are some "creative" solutions in the FAQ (see my signature) but the best thing you could do is ring your local Informix office and ask them how it can be done. This is such a common requirement (and seems to have become a pet hate of mine) that *INFORMIX* need to provide a sensible solution -- not us! Cheers, Kerry S PS: Illustra would let you write your own "UPPERCASE" function, so that's probably going to be Informix's "solution" from now on... ------------------------------------,------------------------------------------ Kerry Sainsbury, kerry@kcbbs.gen.nz | THE INFORMIX FAQ v2.4 Oct 95 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/