Replace Query with records in table

[David McKnight]

I have the following query:

UPDATE Scores INNER JOIN Scores_Clean ON Scores.Home Like "*" &
Scores_Clean.Find & "*" SET Scores.Home =
Replace(Scores.Home,Scores_Clean.Find,Scores_Clean![Replace with]);

It works fine except it I want it to only replace matches that are exact.

 

[John W. Vinson]

It works fine except it I want it to only replace matches that are exact.

Then get rid of the LIKE and wildcards and use an equality instead:

UPDATE Scores INNER JOIN Scores_Clean
ON Scores.Home = Scores_Clean.Find
SET Scores.Home = Replace(Scores.Home,Scores_Clean.Find,Scores_Clean![Replace
with]);