select a.* from a left join b on a.iid like '%'+RTRIM(b.iid)+'%'
create table a (aa varchar(100) ) create table b (bb varchar(10)) go insert into a select '10,11,12,13 ' union select '11,12' union select '12,13' union select ''insert into b select '10 ' union select '11' union select ''go select * from a select * from b select 表A.* from a 表A, b 表B where charindex(','+表B.bb+',' , ','+表A.aa+',')>0 and 表A.aa <>'' godrop table a drop table b
create table b (bb varchar(10))
go
insert into a
select '10,11,12,13 '
union select '11,12'
union select '12,13'
union select ''insert into b
select '10 '
union select '11'
union select ''go
select * from a
select * from b
select 表A.* from a 表A, b 表B
where charindex(','+表B.bb+',' , ','+表A.aa+',')>0 and 表A.aa <>''
godrop table a
drop table b