title: How to find fields containing the TAB character in SQL Server
body: <p>In SQL Server, what is the best way to identify all rows in a table where a certain column contains the <code>TAB</code> character (<code>CHAR(9)</code>)</p>
  
  <p>Is it as simple as </p>
  
  <pre><code>SELECT * FROM MyTable WHERE Field1 LIKE '%' + CHAR(9) + '%'
  </code></pre>