一个困扰多时的sql,求助
表tab中有以下记录：
id     userids
1       11,15,21
2       11,23,45,12
3       55,66,77

我的sql语句中用到一个变量   ls_c，现ls_c= '11 '   ，现想检索tab中userids包含ls_c内容的记录。
请问怎么组合这一语句：
select   *   from   tab   where   ls_c   in   (userids)     ?




------解决方案--------------------
select * from tab where charindex( ', '+ls_c+ ', ', ', '+userids+ ', ')> 0
------解决方案--------------------
select * from tab where charindex( ', '+@ls_c+ ', ', ', '+userids+ ', ') > 0
------解决方案--------------------
Select * from tab where Charindex( ', '+@ls_c+ ', ', ', '+userids+ ', ')> 0
------解决方案--------------------
create table test (id int,userids varchar(100))
insert into test
select 1, '11,15,21 '
union all select 2, '11,23,45,12 '
union all select 3, '55,66,77 '

declare @ls_c varchar(20)
set @ls_c= '11 '

select *
from test
where userids like '% ' + @ls_c + '% '

drop table test

-------------------
id userids
1 11,15,21
2 11,23,45,12


（所影响的行数为 2 行）

------解决方案--------------------
select * from tab where Charindex( ', '+@ls_c+ ', ', ', '+userids+ ', ') > 0


------解决方案--------------------
select * from test where ( ', ' + userids + ', ') like ( '%, ' + @ls_c + ',% ')
楼上，我觉得得这样判断。
避免出现111，211这样的userid会影响like判断

------解决方案--------------------
Declare @ls_c Varchar(10)
Set @ls_c= '11 '
---方法1
Select * From tab Where CharIndex( ', '+@ls_c+ ', ', ', '+userids+ ', ')> 0
---方法2
Select * From tab Where PatIndex( '%, '+@ls_c+ ',% ', ', '+userids+ ', ')> 0
---方法3
Select * From tab Where ', '+userids+ ', ' Like '%, '+@ls_c+ ',% '
------解决方案--------------------
create table yang_kun (id int,userids varchar(100))
insert into yang_kun
select 1, '11,15,21 '
union all select 2, '11,23,45,12 '
union all select 3, '55,66,77 '

declare @ls_c varchar(20)
set @ls_c= '11 '

select * from yang_kun where Charindex( ', '+@ls_c+ ', ', ', '+userids+ ', ') > 0
-------------------------------------------
id userids
1 11,15,21
2 11,23,45,12
------解决方案--------------------
select *
from test
where ', ' + userids + ', ' like '%, ' + @ls_c + ',% '
------解决方案--------------------
---创建测试环境
Create Table tab (id int,userids varchar(100))
Insert Tab Select 1, '11,15,21 '
Union All Select 2, '11,23,45,12 '
Union All Select 3, '55,66,77 '

Select * From Tab