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