Another option is to dynamically build the sql statement.

declare @sql varchar(2000)

set @sql='select * from tbl where id in (' + @idlist +')'

EXEC (@sql)

If the ids are integer, then you will want to remove the qoutes prior to building the string.

Brian