DECLARE @tb_dic_bookclass TABLE ( Id VARCHAR(5), Name VARCHAR(20))
DECLARE @InputStr VARCHAR(50), @OutputStr VARCHAR(200)
INSERT INTO @tb_dic_bookclass
SELECT '001', '歷史'
UNION
SELECT '002', '文學'
UNION
SELECT '003', '數學'
UNION
SELECT '004', '地理'
UNION
SELECT '005', '英語'
SELECT @OutputStr =''
SELECT @OutputStr = @OutputStr+Name+', ' FROM @tb_dic_bookclass
WHERE CHARINDEX(ID , '001,002,003') >0