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

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.
Who is Participating?
radcaesarConnect With a Mentor Commented:
No Its not. Who said this? To run SSIS Packages, You need only SQL Server 2005 (Standard Edition Atleast).

To create package you need BIDS (Business Intelligence Development Studio, A version of VS development environment for SQL Server BI).
This BIDS 2005 will be installed automatically when you perform a full installation of SQL Server.

You can run VS 2008 and BIDS 2005 in the same box. No Issues.
Better use SSIS for this. Its hard to do the FUZZY lookup using T-Sql
lapuccaAuthor 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.
lapuccaAuthor 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.
lapuccaAuthor Commented:
Ignore the last post note.  It is working as described in the url.  My bad.  Thansk.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.