在ntext類型字段中會(huì)有些HTML標(biāo)記，比如<div>/<br>/<font>等，當(dāng)我們做統(tǒng)計(jì)查詢時(shí)，這些內(nèi)容會(huì)影響顯示效果，下面編寫的一個(gè)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