Re: Sorting strings

The "UPPER" function is not available until 7.30. Sean Bradley >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 > > > > > > >