Re: Sorting strings

I've been having the same problem, but I just looked up the 'upper' function in my informix books, and I couldn't find it anywhere. Could you please provide a SQL example? I want my output to look something like this: Abra amazom Cadabra Zebra Thanks so much. On Fri, 4 Sep 1998, Dirk Niemeier wrote: > 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