Re: Sorting strings

Posted in 1998

Manuel A. Daponte Santiago — Fri, 04 Sep 1998 23:47:58 -0400 — source: Informix-list mailing list archive (1991-1998)

This is a multi-part message in MIME format. --------------26BAAE187D1BECDB81904C90 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit There are a couple of solutions here: http://www.iiug.org/techinfo/faq/ifaq05.htm#5 Amir H. Taghinia wrote: > 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 --------------26BAAE187D1BECDB81904C90 Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Manuel Andres Daponte Santiago Content-Disposition: attachment; filename="vcard.vcf" begin: vcard fn: Manuel Andres Daponte Santiago n: Daponte Santiago;Manuel Andres org: GM Group adr: MSC #54, Montehiedra Town Center;;9410 Los Romeros Ave.;San Juan;PR;00926;USA email;internet: mdaponte@prtc.net title: Systems Consultant tel;work: +1 (787) 7514343 tel;home: +1 (787) 2921107 note: ICQ 12214968 x-mozilla-cpt: ;0 x-mozilla-html: FALSE version: 2.1 end: vcard --------------26BAAE187D1BECDB81904C90--