May 18, 2009 at 11:15 am
Hi ,
I am planning to update the street field in the table t_address from a database..
some people addresses are in the format 1225 westminister blvd#2A
I want to update # to Apt ,
Can anyone of you help with the code to accomplish this.
Thank you.
May 18, 2009 at 11:17 am
Check out Books On-Line (BOL). You want the REPLACE() function.
May 18, 2009 at 11:19 am
Have you looked at simply using the Replace command? That should do what you need with the # symbols.
As far as getting addresses into fully formatted versions, your best bet is send it to list processing company and get them to "CASS" the list for you. (CASS is a postal accronym. It's a validation process.)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply