title: Stored Procedure parameter at WHERE IN clause
body: <p>I have a stored procedure and it looks something like this:</p>
  
  <pre><code>SELECT * FROM empTable
  WHERE empCode IN (@employeeCode)
  </code></pre>
  
  <p>The <code>@employeeCode</code> will accept an input from another application where I do NOT have the control of that application. It will give me a <code>string</code> something like this: <code>'M06', 'R02', 'B19', 'C10'</code></p>
  
  <p>When I execute the procedure, it returns me 0 row. However, when I run the query manually in the SQL Server using the following query:</p>
  
  <pre><code>SELECT * FROM empTable
  WHERE empCode IN ('M06', 'R02', 'B19', 'C10')
  </code></pre>
  
  <p>It returns me 15 rows.</p>
  
  <p>I'm suspecting that when the <code>employeeCode</code> accepting the input, it assumes the entire <code>'M06', 'R02', 'B19', 'C10'</code> as ONE <code>string</code>. Can anybody confirm this? If this is true, how am I going to fix it?</p>
  
  <p>Edited: I'm using SQL Server 2000</p>