关于 IN 问题

[jerrie_1]

declare @idlist varchar(2000)
set @idlist='k001,k002,k003'
select * from tb where id in (replace(''''+@idlist+'''',',',''','''))

表中有ID为K001,K002,K003的记录，但用上面的SELECT就是查不到，偶也知道是后面REPLACE的问题，把它作为一个整体来查询。有那位可以修改一下或更好的思路吗？
当然也不推荐用exec

说的太多啦，先谢谢

[fa_ge]

declare @idlist varchar(2000)
set @idlist='k001,k002,k003'
select * from tb where charindex( ','+id+',' ,','+@idlist+',')>0

[fa_ge]

用patindex 也行

[paoluo]

可以使用like



declare @idlist varchar(2000)
set @idlist='k001,k002,k003'
select * from tb where ',' + @idlist + ',' Like '%,' + id + ',%'

[paoluo]

--如果編碼是k001這樣固定四位的話
--可以
declare @idlist varchar(2000)
set @idlist='k001,k002,k003'
select * from tb where @idlist Like '%' + id + '%'

--或者
declare @idlist varchar(2000)
set @idlist='k001,k002,k003'
select * from tb where CharIndex(id, @idlist) > 0

[jerrie_1]

ok

[yonghengdizhen]

归根到底是没有理解字符串和行集的区别