--示例
create function f_str(
@str1 varchar(8000),
@str2 varchar(8000)
)returns varchar(8000)
as
begin
declare @r varchar(8000),@i int
select @r='',@i=charindex(',',@str1+',')
while @i>0
select @r=case
when charindex(','+left(@str1,@i),','+@str2+',')>0
then @r+left(@str1,@i)
else @r end
,@str1=stuff(@str1,1,@i,'')
,@i=charindex(',',@str1+',')
return(case right(@r,1) when ',' then left(@r,len(@r)-1) else @r end)
end
goselect dbo.f_str('B,C,E','B,C')
godrop function f_str
create function f_str(
@str1 varchar(8000),
@str2 varchar(8000)
)returns varchar(8000)
as
begin
declare @r varchar(8000),@i int
select @r='',@i=charindex(',',@str1+',')
while @i>0
select @r=case
when charindex(','+left(@str1,@i),','+@str2+',')>0
then @r+left(@str1,@i)
else @r end
,@str1=stuff(@str1,1,@i,'')
,@i=charindex(',',@str1+',')
return(case right(@r,1) when ',' then left(@r,len(@r)-1) else @r end)
end
goselect dbo.f_str('B,C,E','B,C')
godrop function f_str
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货