Basic information, you'll find here:
http://msdn.microsoft.com/en-us/library/ms177682.aspx[
^]
Below, example code should works:
CREATE TABLE #tof(case_status INT)
INSERT INTO #tof(case_status)
VALUES (1)
INSERT INTO #tof(case_status)
VALUES (2)
INSERT INTO #tof(case_status)
VALUES (3)
INSERT INTO #tof(case_status)
VALUES (4)
INSERT INTO #tof(case_status)
VALUES (5)
DECLARE @status_code NVARCHAR(300)
DECLARE @sql_query NVARCHAR(300)
SET @status_code='1, 2'
SET @sql_query = 'SELECT * ' +
'FROM #tof ' +
'WHERE case_status IN (' + @status_code + ')'
EXEC (@sql_query)
DROP TABLE #tof