title: Searching For Text Including Double Quotes In SQL Server
body: <p>Can anybody tell me how I can query for an item having a double-quote (") in them? The query I am trying to run is</p>
  
  <pre><code>SELECT * FROM Table WHERE Code = 'CAT"A"'
  </code></pre>
  
  <p>This query doesn't return anything although I do have an entry for CAT"A" 
  I can find it using</p>
  
  <pre><code>SELECT * FROM Table WHERE Code LIKE 'CAT%'
  </code></pre>
  
  <p>But the "Code" being used will be variable, so I cannot use LIKE in this case.
  Any help is greatly appreciated :)</p>
  
  <p>G</p>