title: How to escape underscore character in PATINDEX pattern argument?
body: <p>I've found a solution for finding the position of an underscore with PATINDEX :</p>
  
  <pre><code>DECLARE @a VARCHAR(10)  
  SET     @a = '37_21'
  
  PRINT PATINDEX('%_%', @a)                    -- return 1 (false)
  PRINT PATINDEX('%!%', REPLACE(@a, '_', '!')) -- return 3 (correct)
  </code></pre>
  
  <p>Have you other ideas? Like a way to escape the underscore character?  </p>