Tag Archives: Html-Encoding

How to html-encode special characters in T-SQL

When talking to people other than DBAs you need to transport the message contained in your data. Marketing or sales people expect formatted output and the only way to process query results for database mail is to transform them to html. Unfortunately there is no inbuilt function to html-encode special characters in T-SQL. So I decided to work on a semi-complete solution written natively in T-SQL ...