Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
666arc
Starting Member
3 Posts |
 Posted - 2007-08-22 : 07:42:24
|
| AllHow would I go about removing certain commas from an address field.For example, I have the address "Flat 1, 77, Philbeach Gardens" and I only want to remove the comma after the 77 but leave the comma in after the 1.But if the address were just 77, Philbeach Gardens, then I'd want to remove the comma.Thanks |
|
|
Jeff Moden
Aged Yak Warrior
652 Posts |
Posted - 2007-08-22 : 07:53:48
|
| There are a million such problems with free-form address columns. The absolute best way to make correctly formed addresses is to buy some CASS certification software. Such software contains a database of all the correct addresses according to the postal service for the entire country. Of course, such software is pretty much country sensitive so that if you live in, say, Canada, don't expect a program for the United States to work correctly. Such software will also validate the address as being correct (ie, does Flat 1 actually exist?) which, when submitted correctly to the post office, will reduce mailing rates the savings of which will more than pay for the software investment.--Jeff Moden |
 |
|
|
|
|
|
Comma in Address Field