We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

How to do a fuzzy match to antoher table's column?

Medium Priority
196 Views
Last Modified: 2012-05-11
Hi, I'm trying to find possible match between 2 tables based on FirstName and LastName column.  If table B has a similar Fristname and similar lastname to that of table A then list it.  What's the best way to do this?  Thank you.
Comment
Watch Question

Better use SSIS for this. Its hard to do the FUZZY lookup using T-Sql

http://msdn.microsoft.com/en-us/library/ms345128

Author

Commented:
The problem is I have VS2008 and sql 2005 which inhibits the SSIS to run.  Isn't that true that sql 2005 requires VS2005 to run SSIS?  Thanks.
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
I was told wrong information before.  Thank you very much, it does work.  I am able to bring up the BIDS and created a SSIS.  Wow, I wasted a month writing various script for cleaning up database when I could just use this.  However the link you provided for sql 2005 doesn't seem to follow what I see in my version of BIDS.  I cannot follow even the 3rd step of To construct the simplest Fuzzy Lookup package: at the link.  I think I will check out the instruction in sql 2008 for this and hope that will work.  But much appreciation for your help.

Author

Commented:
Ignore the last post note.  It is working as described in the url.  My bad.  Thansk.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.