title: How can i introduce multiple conditions in LIKE operator for MS Access SQL
body: <p>I would like to know, if there is any way, how to achieve something like this in access sql.</p>
  
  <pre><code>select * from my_table where column_name like ('ABC%', 'MOP%');
  </code></pre>
  
  <p>I tried use this: <a href="https://stackoverflow.com/a/1387797/1784053">https://stackoverflow.com/a/1387797/1784053</a> but this seems not to work in Access.</p>
  
  <p>Is there way on how to achieve anything like multiple like conditioning based on dynamic set of conditions? This means, that I cant use <code>OR</code> neither <code>UNION</code> because my set of conditions is dynamic.</p>
  
  <p>Similar question: <a href="https://stackoverflow.com/questions/1387612/how-can-i-introduce-multiple-conditions-in-like-operator">How can i introduce multiple conditions in LIKE operator</a></p>