Tiffany,
You are storing the data in your table as character data not numeric...
John
-----Original Message-----
From: Tiffany - Tech Support [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 19, 2000 6: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.
