Hi, all... I'm trying to order street addresses.
I originally setup the the first field in the address to hold the steet number and made it numeric so it could be ordered. Unfortunately, I found out that some of the addresses had no street number, but were addresses like "No. 10 Magnolia Park", "No. 12 Pecan Park", etc. "No. 10" is what's now going in the street number field, and, of course, that field cannot be numeric, but a character field. However, that's throwing off the ordering of the properties... How would I select out the number, if present, in the street number field and have Cold Fusion order the query output by the number? Thanks for any help! Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4