Hi,
I have come across this issue where I need to do spell check between two name fields.
Database1: Member table - Field name: Member Name
Database2: Customer Table - Field name: Customer Name
Scenario1:
Member Name: John Doe
Customer Name: John Doee
Member Name: ANNA LIKED
Customer Name: ANA LIKED
In the above scenario both name are close match between Member name and Customer Name. I want to write a script which will compare such close association between names and flag it with 'YES' if matches and 'NO' if it do not.
Thanks,
H