Replace Query with records in table

  • Thread starter Thread starter David McKnight
  • Start date Start date
D

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.
 
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]);
 
Back
Top