Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Transact-SQL (2000)  Record comparison

Author  Topic  sajsal Starting Member 4 Posts Posted - 2004-03-18 : 00:30:20 Hi everyone How can I compare two database records in table1 such that the query returns the matched records and their percentages to which they are alike. Actually the site administrator wants a search facility such that whenever he wants to register a new customer, fill out the whole registration form and than before saving the record, system searches the whole database against the provided form data field by field. If a similar record is found against the new customer, system should display it with a similarity percentage. For example the first name and last name match but the address field does not match at all than it is a 66% similar record. There is also a posibility that the first name and last name are exactly the same and street no. of both the records in the address field might be similar. Now the match of first name and last name is 100% but the address %age is say 10% than the system should give an average (in this case 55%). Can anyone help in this regard. Any code will help alot. Regards