在存储过程中where条件in（）的替代做法

--在存储过程中where条件in（）的替代做法
DECLARE @test NVARCHAR(50)
SET @test='48,49,50,51';
SELECT * FROM dbo.TbExamRecord WHERE CHARINDEX(','+CAST(reid AS NVARCHAR(10))+',',','+@test+',')>0

--等同于
SELECT * FROM dbo.TbExamRecord WHERE REID IN(48,49,50,51)