SQL HTML Encoding

fn_htmlencode.sql

create function dbo.fn_HtmlEncode (
   @Html as varchar ( max )
)
returns varchar ( max )
as

/*
select dbo.fn_HtmlEncode('<This is a T&st #>')
*/

begin
   declare @encoded as varchar ( max )
 
   select @encoded =
       replace (
             replace (
                   replace (
                         replace (
                               replace ( @Html, '&' , '&amp;' ),
                         '<' , '&lt;' ),
                   '>' , '&gt;' ),
             ' ' , '+' ),
       '#' , '%23' )
 
  return @encoded
end
go