Re: Sorting (Order by) in SQR

[Christine Maziarz <MaziarzC@ADAMSGOLF.COM>]

Sounds like Philippe is heading where I was going to go.
>From the information given it sounds like although the data in the field is
numeric, the field data type is character.
What is the variable name in the sort?  Are you using # or $, or a variable
retrieved from SQL (&)?


> -----Original Message-----
> From: Philippe DAVID [SMTP:Philippe.DAVID@GLENAT.COM]
> Sent: Friday, May 19, 2000 9:28 AM
> To:   SQR-USERS@list.iex.net
> Subject:      Re: Sorting (Order by) in SQR
>
> What kind of variable type is concerned in your order by ?
> is it not an alphabetical one?
>
>       -----Message d'origine-----
> De:     Hallmark, Robert J [SMTP:robert.j.hallmark@LMCO.COM]
> Date:   vendredi 19 mai 2000 16:16
> À:      SQR-USERS@list.iex.net
> Objet:  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
>