sql server select large text code example

Example: sql server select value large text

SELECT CONVERT(XML, [column_here]) AS [Value]
FROM [TABLE] 

SELECT CAST('<![CDATA[' + CAST(column_here as nvarchar(max)) + ']]>' AS XML) FROM [TABLE]