Select * From TableName Where CharIndex(',2,',','+专长+',') >0
Select * From TableName Where ','+专长+',' Like '%,2,%'
Create Table TEST (编号 Int, 用户名 Varchar(10), 专长 Varchar(50)) Insert TEST Select 1, 'AA', '1,2,12' Union All Select 2, 'BB', '2,3' Union All Select 3, 'CC', '3,4,12' Union All Select 4, 'DD', '2,20,12' GO Select * From TEST Where CharIndex(',2,',','+专长+',') >0Select * From TEST Where ','+专长+',' Like '%,2,%' GO Drop Table TEST --Result /* 编号 用户名 专长 1 AA 1,2,12 2 BB 2,3 4 DD 2,20,12 */
(编号 Int,
用户名 Varchar(10),
专长 Varchar(50))
Insert TEST Select 1, 'AA', '1,2,12'
Union All Select 2, 'BB', '2,3'
Union All Select 3, 'CC', '3,4,12'
Union All Select 4, 'DD', '2,20,12'
GO
Select * From TEST Where CharIndex(',2,',','+专长+',') >0Select * From TEST Where ','+专长+',' Like '%,2,%'
GO
Drop Table TEST
--Result
/*
编号 用户名 专长
1 AA 1,2,12
2 BB 2,3
4 DD 2,20,12
*/