求一个sql语句，查出字段中包含某一个值的记录SQL codeT1IdName11,2,324,5,637,8,9,10,11--用一条sql语句找
求一个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*/