title: SQL Compare list of string values with table without writing to database and retrieve rest of list
body: <p>I have a comma separated list with a lot of values(strings) and I want to compare it to a MS SQL Server 2008 table. I am trying to get which of the values in the list that are not in the table. I don't want to write to the database at all if possible. </p>
  
  <p>I have found this previous post that is similar to my question but I can't quite figure out how to make it work with strings.</p>
  
  <p><a href="https://stackoverflow.com/questions/14872307/comparing-list-of-values-against-table">Comparing list of values against table</a></p>
  
  <p>Any suggestions?</p>