title: Apply like function on an array is SQL Server
body: <p>I am getting array from front end to perform filters according that inside the SQL query.</p>
  
  <p>I want to apply a <code>LIKE</code> filter on the array. How to add an array inside <code>LIKE</code> function?</p>
  
  <p>I am using Angular with Html as front end and Node as back end.</p>
  
  <p>Array being passed in from the front end:</p>
  
  <pre><code> [ "Sports", "Life", "Relationship", ...]
  </code></pre>
  
  <p>SQL query is :</p>
  
  <pre><code>SELECT *
  FROM Skills
  WHERE Description LIKE ('%Sports%')
  
  SELECT *
  FROM Skills
  WHERE Description LIKE ('%Life%')
  
  SELECT *
  FROM Skills
  WHERE Description LIKE ('%Relationship%')
  </code></pre>
  
  <p>But I am getting an array from the front end - how to create a query for this?</p>