title: SQL Server SELECT where any column contains 'x'
body: <p>Using SQL Server 2008, say I have a table called <code>testing</code> with 80 columns and I want to find a value called <code>foo</code>.</p>
  
  <p>I can do:</p>
  
  <pre><code>SELECT * 
  FROM testing 
  WHERE COLNAME = 'foo'
  </code></pre>
  
  <p>Is it possible I can query all 80 columns and return all the results where <code>foo</code> is contained in any of the 80 columns?</p>
  
  <p>Thanks in advance.</p>