A few ways to handle this:

1). Pass multiple VARCHAR parameters to the stored procedure
2). Pass TEXT parameter to the stored procedure and internally splice the
TEXT to VARCHAR chunks and process
3). Pass TEXT parameter that contains XML formatted values rather than list,
then use OPENXML to process

Take a look at this article by Erland Sommarskog for details on some of the
techniques, as well as different methods to split a list to optimize that
part too:
http://www.sommarskog.se/arrays-in-sql-2000.html

In particular those two sections:
http://www.sommarskog.se/arrays-in-s...lnum-unlimited
http://www.sommarskog.se/arrays-in-s...0.html#OPENXML

HTH,

Plamen Ratchev
http://www.SQLStudio.com