I am working on MS-SQL server ver 7.0. I have one database with two tables, each containing various fields such as first name, middle name, surname, address1, address2, city. I need to compare two tables on certain parameters with an objective of sorting mismatched records. Parameters are as follows:
1 Name+Address in totality
2 Name(leaving middle name)+Address in totality
3 Name(leaving middle name)+Address (3 words)
4 Name(leaving middle name)+Address (2 words)
5 Name(leaving middle name and first name first letter only)+Address (3 words)
6 Name(leaving middle name and first name first letter only)+Address (2 words)
1 Name+Address in totality
2 Name(leaving middle name)+Address in totality
3 Name(leaving middle name)+Address (3 words)
4 Name(leaving middle name)+Address (2 words)
5 Name(leaving middle name and first name first letter only)+Address (3 words)
6 Name(leaving middle name and first name first letter only)+Address (2 words)