Find and replace

After importing data, I'm seeing content in several fields where an unusual character lives where an apostrophe should be. For example, this song title: Climb EvÕry Mountain should be Climb Ev'ry Mountain. I am trying to use the Update Multiple Records to replace this, but I cannot seem to get the replace text syntax correct.  This is occuring in several fields in multiple tables.  One field is "Selection Title" -- can you provide the syntax needed in that field? Thank you.