Hey Lewis, What database are you using? It will help identify the functions that you have access to.
William ---------------------------------- William Seiter IT Web Developer / Consultant Is your income limited by the red tape and paperwork? Let SoftEx BackOffice help you. They know how to take care of the 'busy work' of your contracts and let you focus on the 'WOW' factor. http://www.softexconsulting.com/backoffice.cfm ::-----Original Message----- ::From: Lewis Billingsley [mailto:[EMAIL PROTECTED] ::Sent: Tuesday, October 21, 2008 1:28 PM ::To: cf-newbie ::Subject: Numerical Order of Query Results :: ::Hello, :: I have a simple problem, but donââ¬â¢t know how to remedy it. ::I have a query that returns accountIDs among other things ::The query has an Order By AccountID. Everything goes fine if the Account ::Id is only 7 numbers like 0112345, but if the Account ID is 8 numbers as ::in 01103456, the latter number (the 8digit number), which is larger, will ::appear before any of the seven digit numbers. I need it to appear in ::actual numerical order. How can I handle the results of the query to do ::that, or how can I change the query to assure numerical order? :: ::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:4066 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
