So you have data that's not clean? You might want to look around here for Fuzzy Matching articles. If you have SQL Server Enterprise, you can use it in SSIS to clean the data up. Look up "Fuzzy Lookup" and "fuzzy match" in the articles section - there are a bunch. If you have Enterprise, there's a Fuzzy match transformation or whatever in SSIS. (I'm terrible at SSIS, so you might want to ask someone like Koen Verbeeck and see what he says.)