麻烦的in

[lifeiping]

use pubs
go
create table job
(
jobid nvarchar(10) not null primary key,
jobname varchar(20) not null
)
go
insert into job values('4','job4')
insert into job values('5','job5')
insert into job values('6','job6')
insert into job values('7','job7')
insert into job values('8','job8')
insert into job values('9','job9')
insert into job values('10','job10')
insert into job values('11','job11')
go
declare @s nvarchar(100)
set @s='3,4,5,6,7,8,9,10,11,12'
select * from job where jobid in (@s)
这样解决不可行！各位有何高见

[lifeiping]

sqlserver

[哥是我]

DB2？

select * from job where locate(jobid,@s)>0