title: Replacing an apostrophe in a string
body: <p>I have two databases. One has apostrophe in names like O'Bannon and one does not. I need to merge them and find the duplicates. Since it's harder to add the apostrophes I'm tring to remove them instead</p>
  
  <p>But this...</p>
  
  <pre><code>UPDATE Client
  SET Last_Name = REPLACE(''','')
  </code></pre>
  
  <p>Clearly won't work.  How does one escape the '. </p>
  
  <p>I'm using Xojo  (not PHP)</p>