Well, I'm not sure you can have it both ways. Either you sort it numerically, or alphabetically. Where would 01DEMO show up?
The only thing I can think of trying is something like this: ORDER BY CASE WHEN isNumeric(getJobs.accountID) THEN convert(numeric(8),getJobs.accountID) ELSE getJobs.accountID END -----Original Message----- From: Lewis Billingsley [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 28, 2008 10:39 AM To: cf-newbie Subject: Re: Numerical order of query results Dave, This solution actually turned out to be the best on another page because of how query results were delivered as an array to create table cells. But, I now have another problem. One of the account numbers is called 01DEMO which brings up the error that it can't be converted, so I have to find a way to sort the numbers AND include 01DEMO. Is this possible??? Many Thanks, Lewis ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4094 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
