declare @s1 varchar(200),@s2 varchar(200),@s varchar(200) set @s='' set @s1='我们都是来自五湖四海的朋友' set @s2='朋友多了路真的好走吗'while len(@s1)>0 begin if charindex(left(@s1,1),@s2)>0 begin set @s=@s+left(@s1,1) end set @s1=stuff(@s1,1,1,'') endprint @s
declare @Lctext1 varchar(100),@Lctext2 varchar(100) set @Lctext1='我们都是来自五湖四海的朋友' set @Lctext2='朋友多了路真的好走吗'SELECT SUBSTRING(@Lctext2,number,1) as value from master..spt_values where type='p' and number <=LEN(@Lctext2)and CHARINDEX(SUBSTRING(@Lctext2,number,1),@Lctext1)>0 /* value ----- 朋 友 的*/
declare @str1 nvarchar(100), @str2 nvarchar(100) select @str1=N'我们都是来自五湖四海的朋友' , @str2=N'朋友多了路真的好走吗'declare @str nvarchar(100) select @str=isnull(@str,'')+ str1 from ( SELECT distinct SUBSTRING(@str1,number,1) AS [str1] from master.dbo.spt_values where type='p' AND number BETWEEN 1 AND LEN(@str1) ) A inner join ( SELECT distinct SUBSTRING(@str2,number,1) AS [str2] from master.dbo.spt_values where type='p' AND number BETWEEN 1 AND LEN(@str2) ) B on A.str1=B.str2select @str
--or declare @Lctext1 varchar(100),@Lctext2 varchar(100),@s varchar(100) set @Lctext1='我们都是来自五湖四海的朋友' set @Lctext2='朋友多了路真的好走吗' SELECT @s=isnull(@s,'')+SUBSTRING(@Lctext2,number,1) from master..spt_values where type='p' and number <=LEN(@Lctext2)and CHARINDEX(SUBSTRING(@Lctext2,number,1),@Lctext1)>0 select @s as value /* value ----- 朋友的*/
把两个字符串分开一个个字符插进两个表a、b里,然后连接查询, where a.value = b.value
set @s=''
set @s1='我们都是来自五湖四海的朋友'
set @s2='朋友多了路真的好走吗'while len(@s1)>0
begin
if charindex(left(@s1,1),@s2)>0
begin
set @s=@s+left(@s1,1)
end
set @s1=stuff(@s1,1,1,'')
endprint @s
set @Lctext1='我们都是来自五湖四海的朋友'
set @Lctext2='朋友多了路真的好走吗'SELECT SUBSTRING(@Lctext2,number,1) as value
from master..spt_values
where type='p' and number <=LEN(@Lctext2)and CHARINDEX(SUBSTRING(@Lctext2,number,1),@Lctext1)>0
/*
value
-----
朋
友
的*/
declare @str1 nvarchar(100), @str2 nvarchar(100)
select @str1=N'我们都是来自五湖四海的朋友' ,
@str2=N'朋友多了路真的好走吗'declare @str nvarchar(100)
select @str=isnull(@str,'')+ str1
from
(
SELECT
distinct SUBSTRING(@str1,number,1) AS [str1]
from master.dbo.spt_values
where type='p' AND number BETWEEN 1 AND LEN(@str1)
) A
inner join
(
SELECT
distinct SUBSTRING(@str2,number,1) AS [str2]
from master.dbo.spt_values
where type='p' AND number BETWEEN 1 AND LEN(@str2)
) B
on A.str1=B.str2select @str
declare @Lctext1 varchar(100),@Lctext2 varchar(100),@s varchar(100)
set @Lctext1='我们都是来自五湖四海的朋友'
set @Lctext2='朋友多了路真的好走吗'
SELECT @s=isnull(@s,'')+SUBSTRING(@Lctext2,number,1)
from master..spt_values
where type='p' and number <=LEN(@Lctext2)and CHARINDEX(SUBSTRING(@Lctext2,number,1),@Lctext1)>0
select @s as value
/*
value
-----
朋友的*/
where a.value = b.value