SoftadminUtil.Html_ConvertToText

Not available in Cloud edition.
Type: Scalar function

Replaces p- and br-tags with newline, removes the remaining tags and then substitutes the escaped characters. Use this to display the text representation, for example in documents.

This can not be used to ensure there is no HTML displayed as tags can still be created using escaped characters. For example "& lt;script& gt;" would create a script tag. Using unescaped output from this function where HTML can be displayed is considered a security issue.

Pre 7.9.2 behavior

Replaces p- and br-tags with newline and removes the remaining tags. Use this to display the text representation, for example in documents.

Return value: nvarchar(max)

Resulting text.

Parameters

@Text mandatory nvarchar(max)
Html to convert to text.