title: Select * from table where column = (any value from a comma delimited string)
body: <p>The user selects various words from a drop down list and these values get added into a comma delimited string. When passing the string to a stored procedure I want it to <code>select * from</code> a table where that word exists.</p>
  
  <p>Table</p>
  
  <pre><code>id----word
  
  1-----cat
  
  2-----dog
  
  3-----mouse
  
  4-----dog
  </code></pre>
  
  <p>string that is passed into the stored procedure is <code>cat, dog</code> so returning columns 1, 2 and 4. </p>
  
  <p>Is there a way of doing this in sql server?</p>