thanks but I already had gotten it and posted it as solved, i ended up with
order by left(serial, 4) asc, abs(mid(serial, 5,3)) asc >If ordering by the Left() and Right() don't work, can you Select >Left(SerialNum,4) as sYear, Right(SerialNum,Length(SerialNum)-4) as sNum and >then order by sYear, sNum? >Been a while since I've worked in mysql, but several of the suggestions here >look like they should be working. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293943 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4