hello... I have a varchar field in sql2000 that I use as unit #'s for apts. They can enter as "1,2,3a,4b,10". I would like to order that by the unit number, but since its a varchar, it comes out "1,10,2,3a,4b". How would I order it like this: 1,2,3a,4b,10
TIA ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
