title: How to select all records in sql database tables where any column has a particular value
body: <p>I'm trying to find all the tables in my database that contain a particular email address.</p>
  
  <p>The only thing I know is that this means that I'm looking for any column that is a varchar of some length.</p>
  
  <p>I was thinking about some sort of loop through <code>sys.tables</code> and then for each table in that loop, a loop through the rows in the table and then evaluation of each column on each row.</p>
  
  <p>Probably not the best way to go about it but there's things I don't know, particularly:</p>
  
  <ol>
  <li>How better to do this, and</li>
  <li>How to write this query in the first place.</li>
  </ol>
  
  <p>Any assistance will be greatly appreciated.</p>