If I understand right, he wants the alpha order, not the numeric order. To that end, I have no suggestions, db & sql stuff are not my strong skills.
On Thu, Apr 3, 2008 at 3:55 PM, Ian Skinner <[EMAIL PROTECTED]> wrote: > Paul Ihrig wrote: > > 1 > > 101 > > 101010 > > 2 > > 201 > > 202 > > 201010 > > 201020 > > 3 > > 302 > > This is an alphabetical order of numbers. Why the list is being order > alphabetically I can not say without seeing some relevant code. But the > solution is to tell your code to treat this data a numerical data not > character data. > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302660 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4