>> I should be able to do what I want with an IN clause.

You'll have to double-up the quotes around the strings in the parameter:

' ''100'', ''110'', ''120'' '

When you use the EXECUTE command to process you're query, SQL Server will see:

'100','110','120'

However, as Sergey mentioned, you would be better off if you didn't depend on Dynamic SQL. There are scripts that www.swynk.com that will parse a comma delimited list. you could then put the values into a temp table.

Play with both approaces.

-Mike