Handy tip to show HTML code in a report

Handy tip to show HTML code in a report

Here is a handy tip to show the HTML code of the description text from a workorder:

SELECT TOP 10 wo.workorderid 'Workorderid',
REPLACE(REPLACE(CAST(wo.Fulldescription AS NVARCHAR(MAX)),'<','['),'>',']') 'Description' FROM Workordertodescription wo
ORDER BY wo.workorderid DESC

You can use this also for notifications