[AccessD] "fuzzy logic" search

The names aren't consistent either? What's he using as a primary key? I
think you have more problems than incorrect ss#. :(

Susan H.


> My client is having difficulties where the data input people are entering
> duplicate claims because wrong names or SSNs are entered.  He's asked how
> difficult it would be to do a search for the names entered (seems
irrelevant
> if it is wrong) but then has asked how difficult it would be to do a
"fuzzy
> logic" search for SSNs that are different by up to 2 characters.  I don't
> even have a clue how to attack something like that.  Any ideas (other than
> "out the door, no parachute")?
>
> John W. Colby
> www.colbyconsulting.com
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>