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
