We need a script that convert sql text data type contains rich text format (long text) to:
1. nvarchar text, the script have to strip all tags and replace "par" line break with clrf.
2. HTML - keeping the same visual information as in the SQL text data.
Two examples attached.