Re: Deduplication of records

Hi,

"Raymond de Ligt" <rdl_at_dss.nl> wrote in message news:Xns911BB0188E62Frdldssnl_at_213.222.27.9...

> Hi Everybodu, does anyone have some information about how to deduplicate
> records in databases, example how does one prevent that he gets the same
> person Mr. Johnson more than once in the system , once as Mr. Johnson and
> the other time as Mr. Johnsson.
>

if you system has no other unique keys than the name, throw it away. In your example, what, wen Mr. Johnson and a Mr. Johnsson really exists ?
Oh, something come up to my mind, what is, if you have two persons called Smith ...

shaking head ...
Thomas

-- 
Posted from  [212.20.131.226] 
via Mailgate.ORG Server - http://www.Mailgate.ORG