title: I need to use a comma delimited string for SQL AND condition on each word
body: <p>So I have a parameter. Lets say:</p>
  
  <pre><code>@Tags = 'Red,Large,New'
  </code></pre>
  
  <p>I have a field in my table called [Tags]</p>
  
  <p>Lets say one particular row that field contains "Red,Large,New,SomethingElse,AndSomethingElse"</p>
  
  <p>How can I break that apart to basically achieve the following logic, which I'll type for understanding but I know is wrong:</p>
  
  <pre><code>SELECT * FROM MyTable WHERE
  Tags LIKE 'FirstWordInString'
  AND Tags Like 'SecondWordInString'
  AND Tags Like 'ThirdWordInString'
  </code></pre>
  
  <p>But it knows where to stop? Knows if there's just one word? Or two? Or three?</p>
  
  <p>Workflow:</p>
  
  <p>Someone clicks a tag and the dataset is filtered by that tag. They click another and the tag is appended to the search box and the dataset is then filtered by both of those tags, etc.</p>
  
  <p>Thank you!</p>
  
  <p>Update:</p>
  
  <p>This is a product based situation.</p>
  
  <ol>
  <li>When a product is created the creator can enter search tags separated by commas.</li>
  <li>When the product is inserted, the search tags are inserted into a separate table called ProductTags (ProductID, TagID)</li>
  </ol>
  
  <p>So, in the Product table, I have a field that has them separated by string for display purposes in the application side, and these same tags are also found in the ProductTag table separated by row based on ProductID.</p>
  
  <p>What I'm not understanding is how to place the condition in the select that delivers results if all the tags in the search exist for that product.</p>
  
  <p>I thought it would be easier to just use the comma separated field, but perhaps I should be using the corresponding table (ProductTags)</p>