Searching similar records in a table

From: Sajid (sajid622_at_hotmail.com)
Date: 03/26/04


Date: Thu, 25 Mar 2004 21:08:24 -0800

Hi everyone

How can I search 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. If a similar record is
found against the new customer, system should display it
with a similarity percentage. On the basis of this
similarity percentage, administrator decides to save it as
a new record or use the previous one.

Can anyone help in this regard. Any code will help alot.

Regards



Relevant Pages

  • Searching similar records in a table
    ... How can I search database records in table1 such that the ... similarity percentage, administrator decides to save it as ... Can anyone help in this regard. ... Any code will help alot. ...
    (microsoft.public.sqlserver.fulltext)
  • Searching the similar records in database
    ... How can I search database records in table1 such that the ... similarity percentage, administrator decides to save it as ... Can anyone help in this regard. ... Any code will help alot. ...
    (microsoft.public.sqlserver.programming)