AFAIK, you cannot do this. If I am wrong, please correct me.

Maybe you should look at passing in a CSV or XML list as a single VARCHAR parameter, parsing the values, putting them in a temporary table, and joining.

Wow, deja vu. I just typed this same response about 15 minutes ago.

>What is the proper way to pass a list of values via parameter to an IN operator? We have tried the following as a query in the management studio with no luck. The error message returned is as follows:
>
>Msg 102, Level 15, State 1, Line 3
>Incorrect syntax near ','.
>
>
>

>
>declare @joblist as varchar(100)
>
>set @joblist ='006291','006411'
>SELECT * FROM jcprod where cjobno in (@joblist)
>
>

>
>
>Thanks In Advance
>
>Jeff Hibbs
>The Blencowe Group