求一个sql语句，查出字段中包含某一个值的记录

SQL code

T1Id   Name1    1,2,32    4,5,63    7,8,9,10,11--用一条sql语句找出name字段包含5的记录，有点难度吧Id   Name2    4,5,6

SQL code

DECLARE @T1 TABLE([ID] INT,[NAME] VARCHAR(11))INSERT @T1SELECT 1,'1,2,3' UNION ALLSELECT 2,'4,5,6' UNION ALLSELECT 3,'7,8,9,10,11'DECLARE @ID INT SET @ID=5SELECT * FROM @T1 WHERE CHARINDEX(','+LTRIM(@ID)+',',','+NAME+',')>0/*ID          NAME----------- -----------2           4,5,6*/