title: Check whether a string list contains other string list items using SQL Server?
body: <p>I have two dynamic lists. I want to verify one list contains the strings of other list.</p>
  
  <p>for Ex: </p>
  
  <pre><code>        list1 = 'test1, test2, test3, test4, test5'
          list2 = 'how, where, why, test2, test1'
  </code></pre>
  
  <p>I want to validate the second list, whether every string of list2 is in list1 or not? I want to use it in the stored procedure in SQL server.</p>
  
  <p>Could you please provide the solution?</p>