Paul Ihrig wrote: > ORDER BY ascList > > that still gives me > ascList > 132 > 135 > 135,132
It looks to me like you have a de-normalized database scheme there that stores a list of values in a column. If that case then that is the result you are going to get. '132', '135' and '135,132' are three distinct and separate values. If this is the case then you are not going to get a SQL solution. You will need to do something in ColdFusion after the fact. Or better yet, if you can, normalize your database so that you are not storing lists of values in a column. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:305184 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
