Re: Sorting strings

Posted in 1998

Dirk Niemeier — Fri, 04 Sep 1998 08:04:22 +0200 — source: Informix-list mailing list archive (1991-1998)

Hi Amir, try the upper function in your where-clausel to get uppercase and lowercase in the right order. Dirk Niemeier > Hi, > > I'm trying to 'order by' a varchar column in my database but it's > not ordering the way that I want. By default, the database sorts > the word 'allow' AFTER 'Zebra'. I want to change the database's > sorting behavior so it would sort 'allow' BEFORE 'Zebra'. I have > looked into the GLS Guidebook but I cannot find any specific > instructions. Does anyone have any ideas? I am running Informix > On-line Server version 7.2. Thanks. > > -amir