title: How can i get the records that contain a single quotation mark in SQL Server?
body: <p>How can i get the records that contain a single quotation mark in SQL Server?</p>
  
  <p>The following as you guess, is not valid, but you get the point</p>
  
  <pre><code>SELECT [Id], [Name] FROM [People] WHERE Name LIKE '%'%'
  </code></pre>