title: T-SQL CONTAINS with search condition from subquery
body: <p>I have a table containing search values and wish to use CONTAINS to search another table with those values.  The table to search contains email data.</p>
  
  <pre><code>SEARCHTABLE
  ID     VALUE
  1      '*domain1.com'
  2      '*domain2.co.uk'
  
  EMAILTABLE
  
  ID     SENDER                 BODY
  1      'fred@domain1.com'     'body text of email'
  2      'frank@domain1.com'    'body text of email'
  3      'bob@domain3.net'      'body text of email'
  </code></pre>
  
  <p>is there a way to build a query searching the EMAILTABLE with the values in the SEARCHTABLE in a subquery i.e. the equivalent of :  </p>
  
  <pre><code>SELECT * FROM EMAILTABLE where CONTAINS (sender, '*domain.com OR *domain2.co.uk'
  </code></pre>
  
  <p>I'd be grateful for any assistance with this.</p>