Re: change sort order in v4 se

Colin Abercrombie <colin@nzdoctor.co.nz> wrote: :hi , :i need to change the sort order of alpha from ascii sort to character :sort :ie currently the version 4 informix on SCO that i am using sorts :small lower case letters after upercase letters. :ie :sort order alpha produces this list (order by name) :APPLES :SMITH :ZEBADEEE :de laney :mc fadden :lower case letters ect :i need to have y informix report match my access report which kindly :sorts vi alpha (not ascii) and bill g hasn't provided me an option to :change sort order in access either!!! If you don't want to (can't) upgrade to the new versions of Informix that do support this (7.x) your only option is to maintain an extra column in the table that stores all names in lowercase and use that for sorting. That does of course require such a function in every program that updates that column which may be a pain. Nils.Myklebust@ccmail.telemax.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company