title: TSQL Query: Escaping Special Characters
body: <p>I am trying to escape special characters in a TSQL query. I have done this before:</p>
  
  <pre><code>SELECT columns FROM table WHERE column LIKE '%\%%' ESCAPE '\'
  </code></pre>
  
  <p>And it has worked. Now I have tried to do this now:</p>
  
  <pre><code>UPDATE match SET rule_name='31' ESCAPE '\'
  </code></pre>
  
  <p>But it has failed. I know none of the vlaues have a <code>\</code> but it should still work. I am guessing its because it needs a LIKE statement but how else can I escape characters that I am adding to a database?</p>
  
  <p>In addition, does anyone have a link to all the special characters that should be escaped, I couldn't find any documentation on this!</p>
  
  <p>Thanks all for any help</p>