Using a string parameter with 'IN'

[dje1]

Hi
If I write a query with

WHERE CODE IN ('12345,'21443','45678')

as my selection parameters (code is a varchar) it works perfectly. I want to put this into a stored procedure so I have declared a variable @JOBLIST varchar(200). The where clause is changed to

WHERE CODE IN (@JOBLIST)

and I pass to the procedure '12345','21443','45678'. It then throws an error

A Select statement that assigns a value to a variable must not be combined with data-retrieval operations

Any ideas how I can solve this?

Thanks

David

[rmiao]

Try with dynamic sql.