alter function [dbo].[clearhtml] (@maco varchar(8000))
returns varchar(8000)
as
begin
set @maco=REPLACE(@maco,'<BR>',CHAR(13))
if LEFT(@maco,1)='?'
set @maco=RIGHT(@maco,LEN(@maco)-1)
declare @i int
while 1 = 1 and @maco is not null
begin
set @i=len(@maco)
set @maco=replace(@maco, substring(@maco,charindex('<',@maco),
charindex('>',@maco)-charindex('<',@maco)+1),space(0))
if @i=len( @maco )
break
end
set @maco=replace(@maco,' ','')
set @maco=replace(@maco,' ','')
set @maco=ltrim(rtrim(@maco))
--set @maco=replace(@maco,char(9),'')
--set @maco=replace(@maco,char(10),'')
--set @maco=replace(@maco,char(13),'')
return (@maco)
end
returns varchar(8000)
as
begin
set @maco=REPLACE(@maco,'<BR>',CHAR(13))
if LEFT(@maco,1)='?'
set @maco=RIGHT(@maco,LEN(@maco)-1)
declare @i int
while 1 = 1 and @maco is not null
begin
set @i=len(@maco)
set @maco=replace(@maco, substring(@maco,charindex('<',@maco),
charindex('>',@maco)-charindex('<',@maco)+1),space(0))
if @i=len( @maco )
break
end
set @maco=replace(@maco,' ','')
set @maco=replace(@maco,' ','')
set @maco=ltrim(rtrim(@maco))
--set @maco=replace(@maco,char(9),'')
--set @maco=replace(@maco,char(10),'')
--set @maco=replace(@maco,char(13),'')
return (@maco)
end