title: patindex t-sql special characters
body: <p>How to check if any of this <code>!@#$%^&amp;*()_-+</code> special characters exist in a string ?</p>
  
  <p>i tried </p>
  
  <pre><code>SELECT PATINDEX('!@#$%^&amp;*()_-+', 'test-');  
  SELECT PATINDEX('[!@#$%^&amp;*()_-+]', 'test-');  
  SELECT PATINDEX('%[!@#$%^&amp;*()_-+]%', 'test-');  
  </code></pre>
  
  <p>but all returns 0, it should return 5, any help ?</p>