title: SQL Server stored procedure parameter for IN string in WHERE clause
body: <p>Stored procedure <code>ItemList</code> has a string parameter for <code>WHERE</code> clause <code>IN</code> filter:</p>
  
  <pre><code>WHERE Item IN (@FilterStr)
  </code></pre>
  
  <p>It works, if the filter is single item only.</p>
  
  <pre><code>EXEC ItemList 'ABC'
  </code></pre>
  
  <p>How to call the stored procedure, if multiple items need to be passed for the below SQL <code>WHERE</code> clause?</p>
  
  <pre><code>WHERE Item IN ('ABC', 'DEF', 'HJK')
  </code></pre>
  
  <p>Cannot pass it by 'ABC','DEF','HJK'. Because comma will be parameter separator.  Thanks.</p>