title: How to separate (split) string with comma in SQL Server stored procedure
body: <p>I have a <code>checkboxlist</code>. The selected (checked) items are stored in <code>List&lt;string&gt; selected</code>.</p>
  
  <p>For example, value selected is <code>monday,tuesday,thursday</code> out of 7 days</p>
  
  <p>I am converting <code>List&lt;&gt;</code> to a comma-separated <code>string</code>, i.e. </p>
  
  <pre><code>string a= "monday,tuesday,thursday"
  </code></pre>
  
  <p>Now, I am passing this value to a stored procedure as a string. I want to fire query like:</p>
  
  <pre><code>Select * 
  from tblx 
  where days = 'Monday' or days = 'Tuesday' or days = 'Thursday'`
  </code></pre>
  
  <p>My question is: how to separate string in the stored procedure?</p>