UFN_BUILDHTMLNOTE
This function returns an HTML formatted note given a standard text note.
Return
| Return Type |
|---|
| nvarchar(max) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @TEXTNOTE | nvarchar(max) | IN |
Definition
Copy
create function dbo.UFN_BUILDHTMLNOTE
(
@TEXTNOTE nvarchar(max)
)
returns nvarchar(max)
with execute as caller
begin
declare @HTMLNOTE nvarchar(max) = coalesce(@TEXTNOTE, '');
set @HTMLNOTE = replace(@HTMLNOTE, '&', '&');
set @HTMLNOTE = replace(@HTMLNOTE, '<', '<');
set @HTMLNOTE = replace(@HTMLNOTE, '>', '>');
set @HTMLNOTE = replace(@HTMLNOTE, char(13) + char(10), '<BR/>');
set @HTMLNOTE = replace(@HTMLNOTE, char(10), '<BR/>');
set @HTMLNOTE = replace(@HTMLNOTE, char(13), '<BR/>');
return @HTMLNOTE;
end;