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