但是如果'2,4,6,8'这个字符串是已存到数据库里的怎么办? create table ta(a int) insert ta select 1 insert ta select 2 insert ta select 3 insert ta select 4 insert ta select 5 insert ta select 6 go create table tb(b1 nvarchar(50),b2 varchar(30)) insert tb select '2,4,6,8','admin' insert tb select '2,3,4,5','tuser' go select ta.a from ta where convert(varchar,ta.a) in( select distinct tb.b1 from tb where tb.b2='admin') order by ta.a desc go drop table ta,tb go
create table tb(a int) insert tb select 1 insert tb select 2 insert tb select 3 insert tb select 4 insert tb select 5 insert tb select 6 go select a from tb where charindex(','+cast(a as varchar(5))+',',','+'2,4,6,8'+',')>0 order by a desc go drop table tb go
create table ta(a int)
insert ta select 1
insert ta select 2
insert ta select 3
insert ta select 4
insert ta select 5
insert ta select 6
go
create table tb(b1 nvarchar(50),b2 varchar(30))
insert tb select '2,4,6,8','admin'
insert tb select '2,3,4,5','tuser'
go
select ta.a from ta where convert(varchar,ta.a) in(
select distinct tb.b1 from tb where tb.b2='admin') order by ta.a desc
go
drop table ta,tb
go
insert tb select 1
insert tb select 2
insert tb select 3
insert tb select 4
insert tb select 5
insert tb select 6
go
select a from tb where charindex(','+cast(a as varchar(5))+',',','+'2,4,6,8'+',')>0 order by a desc
go
drop table tb
go
如果用vc编程,又怎样实现?感谢了!