Re: Sorting (Order by) in SQR

[Wendy Stern <wstern@NUI.COM>]

Use leading zeros on your numbers, otherwise no.

Wendy Stern
Email: wstern@nui.com
Tel:  (908) 289-5000 Ext. 5481
Fax: (908) 354-6355

> ----------
> From:         Hallmark, Robert J[SMTP:robert.j.hallmark@LMCO.COM]
> Reply To:     sqr-users@list.iex.net
> Sent:         Friday, May 19, 2000 10:15 AM
> To:   SQR-USERS@list.iex.net
> Subject:      Sorting (Order by) in SQR
>
> Is anyone aware of a way to get an actual numerical sort in SQR?
> For example, If I do an order by on a numerical field it currently sorts
> as
> follows:
>
> 1
> 123
> 21
> 212
> 35
> 4
>
> Is there a way to get it to sort as follows:
>
> 1
> 4
> 21
> 35
> 123
> 212
>
>
> Thanks
>
>
> Bob
>