34,838
社区成员




declare @tb table (s varchar(50))
insert into @tb select 'abc'
insert into @tb select 'ab'
insert into @tb select 'ac'
select * from @tb
where patindex('%'+s+'%','abcd')>0
create table tb(col1 varchar(5))
insert into tb select 'ab'
insert into tb select 'cd'
insert into tb select 'ef'
declare @v varchar(20)
set @v='acdefg '
select * from tb
where patindex('%'+col1+'%',@v)>0