> How would I select out the number, if present, in the street number field
have you tried Order by right(StreetNo, len(StreetNo)-4) The above might help some but not accurate for all cases. Joe Eugene > -----Original Message----- > From: Rick Faircloth [mailto:[EMAIL PROTECTED] > Sent: Friday, March 28, 2003 10:48 PM > To: CF-Talk > Subject: Any wanna help? Trying to order output by the number that's > part of a varchar field... > > > 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 > > > Rick Faircloth > WhiteStoneMedia.com > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
