I want to compare names in two tables but haven't found the best way to accomplish this. I know it's not a perfect science but I thought the LIKE operator would be a good start.
C_Name C2_Name
Darin Samuel
Sam Darren
Frank Bill
I'd like to compare the names in these two tables and list the names from C_Name that are close to any name in C2_Name.
Any suggestions?
C_Name C2_Name
Darin Samuel
Sam Darren
Frank Bill
I'd like to compare the names in these two tables and list the names from C_Name that are close to any name in C2_Name.
Any suggestions?