Create Function [dbo].[f_trimstr](@str nvarchar(4000))
returns nvarchar(4000)
AS
begin
declare @d int;
declare @dd int;
declare @sumstr nvarchar(4000);
while (Charindex('<',@str)!=0 and Charindex('>',@str)!=0)
begin
set @d = Charindex('<',@str);
set @dd = Charindex('>',@str);
set @sumstr = Substring(@str,1,@d-1);
set @str = Substring(@str,@dd+1,len(@str));
set @str = @sumstr+@str;
end
set @str=Replace(@str,' ','')
return @str;
end
注:charindex(@name,Ttopic)>0 判断@name在字符Ttopic中首次出现的位置... 加>0,则表示@name在Ttopic中存在...
substring 方法用于提取字符串中介于两个指定下标之间的字符。substring 方法返回的子串包括 start 处的字符,但不包括 end 处的字符