title: sql In clause with wildcards (DB2)
body: <p>Is there anyway to use wildcards in a clause similar to a "in", like this</p>
  
  <pre><code>select * from table where columnx xxxxxxx ('%a%','%b%')?
  </code></pre>
  
  <p>I know I can do:</p>
  
  <pre><code>select * from table where (columnx like '%a%' or columnx like '%b%')
  </code></pre>
  
  <p>But I'm looking for an alternative to make the querystring shorter.</p>
  
  <p>BTW: I'm not able to register any custom functions, nor temp tables, it should be a native DB2 function.</p>
  
  <p>I found this similar answer for oracle and SQLServer:</p>
  
  <p><a href="https://stackoverflow.com/questions/3014940/is-there-a-combination-of-like-and-in-in-sql">Is there a combination of &quot;LIKE&quot; and &quot;IN&quot; in SQL?</a></p>