给你个存储过程可以实现你的要求
create procedure test (@s varchar(100),@s1 varchar(20),@out varchar(10) output)
as
declare @i int,@str varchar(2000)
set @str=''
set @i=1
while @i<=len(@s1)
begin
set @str=@str+'%'+substring(@s1,@i,1)
set @i=@i+1
end
select @str=substring(@str,2,8000)if patindex('%'+@str+'%',@s)>0 or patindex('%'+@str+'%',reverse(@s))>0
--print '有'
set @out='yes'
else
--print '无'
set @out='no'
go--调用
declare @s varchar(100),@s1 varchar(20),@out varchar(10)
set @s1='河南商务'
set @s='河南省商务'
exec test @s,@s1,@out outputprint @out
--结果
yes
create procedure test (@s varchar(100),@s1 varchar(20),@out varchar(10) output)
as
declare @i int,@str varchar(2000)
set @str=''
set @i=1
while @i<=len(@s1)
begin
set @str=@str+'%'+substring(@s1,@i,1)
set @i=@i+1
end
select @str=substring(@str,2,8000)if patindex('%'+@str+'%',@s)>0 or patindex('%'+@str+'%',reverse(@s))>0
--print '有'
set @out='yes'
else
--print '无'
set @out='no'
go--调用
declare @s varchar(100),@s1 varchar(20),@out varchar(10)
set @s1='河南商务'
set @s='河南省商务'
exec test @s,@s1,@out outputprint @out
--结果
yes
or
select * from t where col like '%河%南%商%务%'
selcect field1 from table1 where field like '河南_商务'不过有局限性