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:4061 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
