> ItemNum Sort1 Sort2 > Item1 - 1 - 1 > Item1 - 2 - 2 > Item2 - 1 - 2 > Item2 - 2 - 1 > Item3 - 1 - 3
(Disclaimer: I have not had my coffee yet. So hopefully a more alert mind will stumble by shortly ..) I do not quite understand the desired output. The example seems as if it is just ordered by: ItemNum, Sort1, Sort2. I am sure it is not that simple. Could you explain how the desired results are different? -Leigh ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3267 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
