You can try to do an LPAD to Three characters with 0. This should place
them in the correct order.
> -----Original Message-----
> From: Keith Purtell [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, June 28, 2001 9:07 AM
> To: KCFusion
> Subject: [KCFusion] Ordering numbers from SQL
>
> I've seen this somewhere but now I can't find the solution. I have a query
> where the SQL uses a standard ORDER BY option. It's not recognizing the
> difference between two and three-digit numbers. How can I overcome this
> problem? Sample results from CFOUTPUT ...
>
> 11 12 30 300 303 31 312 356 361 40 45 50
>
> Keith Purtell, Web/Network Administrator
> VantageMed Operations (Kansas City)
> http://www.vmdc.net/
>
> CONFIDENTIALITY NOTICE: This email message, including any attachments, is
> for the sole use of the intended recipient(s) and may contain confidential
> and privileged information. Any unauthorized review, use, disclosure or
> distribution is prohibited. If you are not the intended recipient, please
> contact the sender by reply email and destroy all copies of the original
> message.
>
>
>
> ______________________________________________________________________
> The KCFusion.org list and website is hosted by Humankind Systems, Inc.
> List Archives........ http://www.mail-archive.com/cf-list@kcfusion.org
> Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
> To Subscribe.................... mailto:[EMAIL PROTECTED]
> To Unsubscribe................ mailto:[EMAIL PROTECTED]
>
______________________________________________________________________
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives........ http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe.................... mailto:[EMAIL PROTECTED]
To Unsubscribe................ mailto:[EMAIL PROTECTED]