If you ever have to do things like compare addresses from Microsoft Dynamics GP with addresses from another system you know what a giant pain it can be. Make sure you check out Mr. Excel's Fuzzy Match video for some help with this problem.
Sadly, I didn't watch this video until after we had finished matching customer records.