title: SQL Server: how to insert the ' character
body: <p>I need to insert some string with ' in it, for example 'x.y.x', After some research I discovered the following syntax:</p>
  
  <pre><code>table_b.element = 'replace('x.y.x','',''')'
  </code></pre>
  
  <p>the problem is that SQL Server gives me an error:</p>
  
  <blockquote>
    <p>Unclosed quotation mark after the
    character string ')</p>
  </blockquote>
  
  <p>How can I solve this case? I spent about 2 hours on this.</p>
  
  <p>Is there an escape character that I need to use?</p>