title: How to search Special character (%) in SQL Server 2008
body: <p>I have a record with a value <code>Jacj%25011987</code>. I wanted to search the record with <code>%</code> as a character in a string.</p>
  
  <p>I wanted to search this record using the <code>Like</code> in <code>where</code> clause.</p>
  
  <p>I tried these queries, but they didn't work:</p>
  
  <pre><code>Select * 
  From Table1 With (Nolock) 
  Where Column1 like '%\%%'
  
  Select * 
  From Table1 With (Nolock) 
  Where Column1 like '%'%%'
  </code></pre>
  
  <p>Thanks
  Parag</p>