OK, I changed the ORDER BY to Route_Name and Pick_Up and it is ordering fine except for one school, the high school. What I am getting is routes 10-23 first, then routes 6-9 are displaying. I know what SQL Server is doing, it sees the number 1 in front of the other numbers and is assuming that thsese are first, and on down the line. So how do I accommodate this? Do I need to put a field in the table that speficies which order each route is supposed to be?
Thanks, Bruce ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295147 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
