title: SQL Server - Sql query like operator with special characters
body: <p>We want to allow all below special characters in search query based on which results should be available to end user. so we enter all below values in one column itself and now want to run sql query with Like operator.</p>
  
  <ul>
  <li>!@#$%^&amp;*()-_=+[]{}\|;':",./&lt;>?</li>
  </ul>
  
  <p>I looked for all possible solution like ESCAPE character, square bracket &amp; so on.
  But it only works till </p>
  
  <p>select * from table
  where title like '!@#$%[^]' ESCAPE '\'</p>
  
  <p>As soon as i add '&amp;', no rows are returned.</p>
  
  <p>It seems i am missing something here.</p>