title: SQL Server : UPDATE, SET with apostrophe in data
body: <p>The update statement below is throwing an error because of the ' within the ''</p>
  
  <pre><code>UPDATE Table 
  SET [Company Name] = 'O'Donald Media Inc' 
  WHERE [Company Name] = 'O'Donald Media  Inc'
  </code></pre>
  
  <p>Does anyone have a way to handle this? </p>
  
  <p>Thanks</p>