In the last episode (Jul 09), CVIOG at UGA said:
> I have a fairly basic question: How do I sort
> numerically? Normally when I query using "ORDER BY
> (field)", it orders by the first digit (i.e. 1, 10, 2,
> 21, 3, 32) rather than by number (1, 2, 3, 10, 21,
> 32).
Either alter the table to mak
ted from each other
My boss is smart :)
> -Original Message-
> From: CVIOG at UGA [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, July 09, 2002 4:22 PM
> To: [EMAIL PROTECTED]
> Subject: Basic Q's: Numerical Sorting
>
>
> I have a fairly basic question: How do I sor
It looks like your field is a text field rather than BIGINT or some
numerical field. Changing the field type should solve your problem.
Serge.
- Original Message -
From: "CVIOG at UGA" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 09, 2002 4:22
I have a fairly basic question: How do I sort
numerically? Normally when I query using "ORDER BY
(field)", it orders by the first digit (i.e. 1, 10, 2,
21, 3, 32) rather than by number (1, 2, 3, 10, 21,
32).
Thanks for any help
Dave
__
Do You Yaho
