Using a variable with IN

[Dana]

I am trying to create a stored proc that will allow me to accept a list into a variable and then use that variable in a where clause. Example

CREATE PROCEDURE RPTCCLCallCount (@ICat varchar(100)) AS

SELECT col1, col2, col3
FROM table1
WHERE field1 = X
AND field2 IN (@ICat)


This does NOT work even though it compiles and will run in query window. Someone PLEASE help!

Thanks, thanks, thanks!