title: how to use many LIKE conditions in SQL easily?
body: <p>I want to use many LIKE conditions in my query. I couldn't find a practical solution. I tried CONTAINS but it doesn't work. </p>
  
  <p>Instead of using this</p>
  
  <pre><code>where EIO.DigiAddress like '%abc@abc.com%'
  or EIO.DigiAddress like '%def@def.com%'
  or EIO.DigiAddress like '%ghi@ghi.com%'
  </code></pre>
  
  <p>I want to use something like this:</p>
  
  <pre><code>CONTAINS(EIO.DigiAddress,'%abc@abc.com%', '%def@def.com%', '%ghi@ghi.com%')
  </code></pre>
  
  <p>OR</p>
  
  <pre><code>EIO.DigiAddress IN ('%abc@abc.com%', '%def@def.com%', '%ghi@ghi.com%')
  </code></pre>