在ntext類型字段中會有些HTML標(biāo)記，比如<div>/<br>/<font>等，當(dāng)我們做統(tǒng)計查詢時，這些內(nèi)容會影響顯示效果，下面編寫的一個SQL函數(shù)可以去除這么標(biāo)記。
USE [COMMON]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE FUNCTION [dbo].[fun_RemoveHtml]
(
@input VARCHAR(8000)
)
RETURNS VARCHAR(8000)
AS
BEGIN
declare
@Result varchar(8000),
@start int,
@end int,
@len int
set @input = @input+'<>'
set @Result = ''
set @len=len(@input)
set @start = charindex('<',@input,1)
set @end = charindex('>',@input,@start)
while(@start<@end)
begin
if(@start<>1)
set @Result = @Result + substring(@input,1,@start-1)
set @len = @len - @end
set @input = substring(@input,@end+1,@len)
set @start = charindex('<',@input,1)
set @end = charindex('>',@input,@start)
end
RETURN replace(@Result,' ','')
END