title: Using Like T SQL Statement to search and replace quotation marks
body: <p>Because the quotation mark is a special character is there a way to replace all quotation with nothing</p>
  
  <p>Original Query</p>
  
  <pre><code>Update table X
  Set mycolumn = Replace(mycolumn,''','')
  Where mycolumn like '%'%'
  </code></pre>
  
  <p>Error</p>
  
  <blockquote>
    <p>(Incorrect SQL Syntax - Unclosed quotation mark after the character string ''')</p>
  </blockquote>