There is a good discussion here: https://social.msdn.microsoft.com/forums/sqlserver/en-US/86b046c9-e1a0-4d26-8ab9-25b99ebcbb35/giving-hyperlink-in-textnvarchar-column-of-sql-table