Hi Tiffany,
This field is apparently character / text not numeric.
Text fields are left-justified, and sorted starting from the left.
So all the 1's will sort first, then all the 2's, etc.
Ben
> -----Original Message-----
> From: Tiffany - Tech Support [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, April 19, 2000 4:34 PM
> To: [EMAIL PROTECTED]
> Subject: Silly question from a novice
>
> This is probably the most lame question:
>
> When you do an ORDER BY in a query with a variable that will display
> numbers, of course it lists all the numbers like this:
>
> 1
> 12
> 20
> 6
> 70
> 9
>
> Instead of 1, 6, 9, 12, 20, 70 Why does it do that? And how can I get it
> to order them correctly?
>
> Thanks!
> _____________________________
> Tiffany
> Technical Support
> the spa! online services
> [EMAIL PROTECTED] (413)539-9818
>
> --------------------------------------------------------------------------
> ----
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
