title: How do I escape _ in SQL Server?
body: <p>I am trying to escape the underscore character in a <code>LIKE</code> Statement. I have tried to use the <code>ESCAPE</code> keyword as follows: </p>
  
  <pre><code>COLUMNNAME NOT LIKE '%[\_]xyz%' ESCAPE '\'
  </code></pre>
  
  <p>but it doesn't work. It is still filtering out <code>%xyz%</code> when I really want it to filter out <code>%_xyz%</code>.</p>
  
  <p>If not by the <code>ESCAPE</code> keyword, how else can this be accomplished?</p>
  
  <p>Any help is appreciated.</p>