Hello!

My company has a database with customer information (SQL Server 7.0).
My boss wants me to formalize the address (USA address).

The street address format is like this (city, state, zip are not my 
concern).
(I know that there will be exceptions and I will ignore them if I can 
recognize them to be exceptional.)

street_number [direction] street_name [street_suffix] [suite_mark] 
[suite_number]

For example:
123 N. Wilshire Blvd. # 707

Variations:
123 North Wilshire Blvd. Ste. 707
123 North Wilshire Boulevard Suite 707
....

(even, "North" can be name of street)

I think I need to analyze variation sets for different cases and use regex 
to replace.

Does anyone have this kind of experience?

TIA.
Sam