you could add 2 columns in your sql: 1 with left(serial_number_column, 4) [if the year part of sn is always 4 digits], the other with the rest of the serial number, and sort the results first by one and hen y the other. exact sql syntax would be db-specific
-- --- Azadi Saryev Sabai-dee.com http://www.sabai-dee.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293932 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
