title: SQL Server query syntax with single quote
body: <p>I have in my database KIA car model like <code>CEE'D</code>.</p>
  
  <p>How to write right syntax to get all car where model = <code>CEE'D</code></p>
  
  <p>Now I am using semipart of model</p>
  
  <pre><code>SELECT make, model 
  FROM Cars 
  WHERE model LIKE '%CEE%'
  </code></pre>
  
  <p>But now I need to get by full model name.</p>
  
  <p>How to write right syntax in this case?</p>