Sql版本除去html并截取指定长度的字符串

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
Go
----截取字符串，并出去html
create FUNCTION [dbo].[CutString] (@str varchar(1000),@length int) 
RETURNS varchar(1000) AS 
BEGIN
 declare @mainstr varchar(1000)
 declare @substr varchar(1000)
 if(@str is not null or @str!='')
 begin
  set @mainstr=dbo.regexReplace(@str,'<[/w/W]*?>','',1,1)
  set @mainstr=dbo.regexReplace(@mainstr,'&[/w/W]*?;','',1,1)
  if len(@mainstr)<=@length
     set @substr=@mainstr
  else
     set @substr=substring(@mainstr,1,@length-2)+'..'
 end
 return @substr
END