Address Standardization

Ok...I'm sick of this.

I'm migrating data from three (third-party, propietary) systems that my company has been using into one common system. The problem with this is that address information in these systems is about as standardized as a bag of rocks. One product simply has 6 address lines, and does not segregate the information (city, state, zip, etc...). Another one has dedicated lines, but users have taken it upon themselves to "invent" ways to enter data (international customers/vendors have data in weird fields, but no rhyme, reason, or cohesion to the madness). The third one is just as bad.

I'm looking for a script-based, SQL implemenation (stored procedures?) for standardizing the addresses into a common format. Does anyone know of anything?

if you're doing this yourself, use 6 address lines

you can also purchase software for this purpose, but i don't have first-hand experience with any

Greatest common factor?

yeah, something like that

hey there,
did you have any success getting sql stored procedures to do the address standardization/matching?
even a set of rules would get me started and i could build one myself.....
cheers,
harry.