title: Remove all apostrophes in field with T-SQL
body: <p>I have a value in database and it contains a few apostrophes like...........</p>
  
  <blockquote>
    <p>It's a good day. He's so happy.</p>
  </blockquote>
  
  <p>Result must be.....</p>
  
  <blockquote>
    <p>Its a good day. Hes so happy.</p>
  </blockquote>
  
  <p>What T-SQL statement can I use to remove the apostrohe?</p>