title: Is there any way to combine IN with LIKE in an SQL statement?
body: <p>I am trying to find a way, if possible, to use IN and LIKE together. What I want to accomplish is putting a subquery that pulls up a list of data into an IN statement. The problem is the list of data contains wildcards. Is there any way to do this? </p>
  
  <p>Just something I was curious on.</p>
  
  <pre><code>Example of data in the 2 tables
  
  Parent table
  
  ID    Office_Code   Employee_Name
  1     GG234         Tom
  2     GG654         Bill
  3     PQ123         Chris
  
  Second table
  
  ID    Code_Wildcard
  1     GG%
  2     PQ%
  </code></pre>
  
  <hr>
  
  <p>Clarifying note (via third-party)</p>
  
  <p>Since I'm seeing several responses which don't seems to address what Ziltoid asks, I thought I try clarifying what I think he means.</p>
  
  <p>In SQL, "<code>WHERE col IN (1,2,3)</code>" is roughly the equivalent of "<code>WHERE col = 1 OR col = 2 OR col = 3</code>".</p>
  
  <p>He's looking for something which I'll pseudo-code as </p>
  
  <pre><code> WHERE col IN_LIKE ('A%', 'TH%E', '%C')
  </code></pre>
  
  <p>which would be roughly the equivalent of </p>
  
  <pre><code> WHERE col LIKE 'A%' OR col LIKE 'TH%E' OR col LIKE '%C'
  </code></pre>
  
  <p>The Regex answers seem to come closest; the rest seem way off the mark.</p>