Using SQL2K (It works, I tried it)- select cast(textnum as int) as orderednum from tablename order by orderednum
using access (I think this is right, I didn't try it) select val(textnum) as orderednum from tablename order by orderednum Matthew Small IT Supervisor Showstopper National Dance Competitions 3660 Old Kings Hwy Murrells Inlet, SC 29576 843-357-1847 http://www.showstopperonline.com -----Original Message----- From: Jillian Carroll [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 9:50 AM To: CF-Talk Subject: Sorting Query Results - WAS Sorting Numbers I have a query that returns a list of tools and their ID numbers. The ID numbers range from 1-1500. How can I get the numbers to sort numerically instead of by ascii (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 100, 101, etc.)? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
