title: Passing multiple values for one SQL parameter
body: <p>I have a CheckBoxList where users can select multiple items from the list. I then need to be able to pass these values to my Stored Procedure so they can be used in a WHERE condition like:</p>
  
  <pre><code>WHERE ID IN (1,2,3)
  </code></pre>
  
  <p>I tried doing this so that its a nvarchar parameter and i pass the string <code>1,2,3</code> with:</p>
  
  <pre><code>WHERE ID IN (@IDs)
  </code></pre>
  
  <p>But this returned the following error:</p>
  
  <pre><code>Conversion failed when converting the nvarchar value '1,2,3' to data type int
  </code></pre>
  
  <p>Any help would be much appreciated!</p>