i would like to be able to compair 2 tables against each other to find similar address matches.
I first need to standerdise my data in each table and insert this data into temp tables.
(2) change all data to same case (upper or lower, doesn't matter which).
(3) strip out all punctuation and all extra spaces
(4) parse the space-delimited elements and standardize all descriptive words such as "NORTH" to "N", "STREET" to "ST", substitute soundex values for uncommon words, etc. For this task I used the Postal Systems's standard abbreviations.
Can some one help me as to how i can achieve this?
I am using t-SQL on SQL SERVER 2005..