title: Is there a combination of "LIKE" and "IN" in SQL?
body: <p>In SQL I (sadly) often have to use "<code>LIKE</code>" conditions due to databases that violate nearly every rule of normalization. I can't change that right now. But that's irrelevant to the question.</p>
  
  <p>Further, I often use conditions like <code>WHERE something in (1,1,2,3,5,8,13,21)</code> for better readability and flexibility of my SQL statements.</p>
  
  <p>Is there any possible way to combine these two things without writing complicated sub-selects?</p>
  
  <p>I want something as easy as <code>WHERE something LIKE ('bla%', '%foo%', 'batz%')</code> instead of this:</p>
  
  <pre><code>WHERE something LIKE 'bla%'
  OR something LIKE '%foo%'
  OR something LIKE 'batz%'
  </code></pre>
  
  <p>I'm working with SQl Server and Oracle here but I'm interested if this is possible in any RDBMS at all.</p>