I have 2 tables. FullName and InputName. FullName has a primary key column Id and Name column. InputName has no index and consists of a InName column only. I want to update the data in the InputName table based on the values on the FullName table.
So, in the InputName table there might be Tony D Jones, in the FullName table Tony D Jones is shown as T D Jones. I want to update the InputName table to match that in the FullName table. Where a sufficiently close match is not found, no action is taken. How would I do that please.
The discrepancy between the names in the tables arises because I am scraping the data from different sources from the web, all of which record the same people in slightly different ways and I need to make regular the names in the dbase.
Thanks for all and any help.