Re: ORDER BY

[srsqr Dsr <srsqr@THEMAIL.COM>]

you may want to trim the spaces. use the trim function depending on the 
software you use.

****** Original Message ******
From: Chuck Harkness <c.a.harkness@LARC.NASA.GOV>
Sent: Wed 03/14/2001 03:27 PM
To: SQR-USERS@list.iex.net
Subject: ORDER BY
Hello!
>
>  I am trying to use an order by clause on a char field, but the order
>
>doesn't come out quite like the customer wanted.  For example, I have
>the
>
>values: 1,1SL,1SM,1UP,100,197,198,199 and 1000.  The order by clause in
>SQR
>
>produces the following order:
>
>
>
>1
>
>100
>
>197
>
>198
>
>199
>
>1SL
>
>1SM
>
>1UP
>
>1000
>
>
>
>I would like the order to be 1,1SL,1UP,100,197,198,199,100.  Does anyone
>
>have any suggestions?
>
>
>
>Thank you,
>
>  Chuck
>
>
>
>
>

Regards,

SRSQR

__________________________________________________________________
Make A Buck Or Two @ TheMail.com - Free Internet Email
Sign-up today at http://www.themail.com/ref.htm?ref=914409