Re: Sorting strings

Posted in 1998

Paul Roberts — 4 Sep 1998 16:04:43 GMT — source: Informix-list mailing list archive (1991-1998)

>> 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'. Easy: order by col_name desc will put 'allow' BEFORE 'Zebra'. (joke) - Paul