HtmlEncode

Encodes a string that may contain HTML character entity references.

Syntax:

SELECT SQLHTTP.net.HtmlEncode ( @String )

Arguments:

Name	Type	Description
@String	nvarchar(MAX)	Any character string, variable, or expression.

Return Type:

nvarchar(max)

Remarks:

Sample Usage:

Encoding a string to another string containing HTML character entity references:

SELECT SQLHTTP.net.HtmlEncode(‘I can now encode & decode an HTML string using SQL Server’)

———————————————————————————————–
I can now encode & decode an HTML string using SQL Server