 <p>What you need to do inside your stored procedure is split the comma delimited list of numbers into a list of single values in rows. Once you have this you can use <code>WHERE myCol IN(SELECT v FROM @r)</code>, or use an INNER JOIN instead of IN. One point you might have to watch for is that you have leading zeros - if you want to keep those you will need to use strings instead of integers.</p> <p>There are lots of articles around on the subject of splitting delimited values into rows, you could start <a href="http://stackoverflow.com/questions/2647/how-do-i-split-a-string-so-i-can-access-item-x">here</a>.</p>