Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Microsoft SQL Server > Re: SQL Stateme...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 3 of 7 Topic 11031 of 11517
Post > Topic >>

Re: SQL Statement Problem : Separate long varchar into word seqments

by eisaacs@[EMAIL PROTECTED] May 12, 2008 at 05:33 PM

You might also want to look into address normalization tools,
depending on how much data you're talking about.  The standardized/
normalized USPS addresses are a lot shorter than the addresses people
tend to give you.  Things like Avenue are shortened to AVE and North
becomes N, etc.  Normalizing the addresses might help you out a lot.

If you put in an address here at the USPS site in the link below, it
will normalize it as an example:
http://zip4.usps.com/zip4/welcome.jsp

You might be able to create a webservice that uses this website to
normalize all your addresses, or buy some third-party tool that does
the same.

That's probably going in another direction from what you're thinking,
but if you're mailing items, it's also worth the cost to verify that
the addresses are valid before mailing.
 




 7 Posts in Topic:
SQL Statement Problem : Separate long varchar into word seqments
jephperro <jeff.perrea  2008-05-09 12:45:21 
Re: SQL Statement Problem : Separate long varchar into word seqm
Erland Sommarskog <esq  2008-05-11 21:46:20 
Re: SQL Statement Problem : Separate long varchar into word seqm
eisaacs@[EMAIL PROTECTED]  2008-05-12 17:33:26 
Re: SQL Statement Problem : Separate long varchar into word seqm
--CELKO-- <jcelko212@[  2008-05-13 12:13:30 
Re: SQL Statement Problem : Separate long varchar into word seqm
steve <rog11228@[EMAIL  2008-05-14 03:23:23 
Re: SQL Statement Problem : Separate long varchar into word seqm
steve <rog11228@[EMAIL  2008-05-16 19:18:06 
Re: SQL Statement Problem : Separate long varchar into word seqm
Ed Murphy <emurphy42@[  2008-05-19 23:08:24 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Wed Dec 3 1:15:58 CST 2008.