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]

Similar codes

0 vote206 views1 answer
Error code 1241 mysql
SQL
0 vote193 views1 answer
Psql datestyle
SQL
0 vote200 views1 answer
Order by in codeigniter query builder
SQL
0 vote187 views1 answer
2020 new year
SQL
0 vote236 views1 answer
Sql doesn't contain
SQL
0 vote209 views1 answer
Nvl2 syntax
SQL
0 vote216 views1 answer
Sql query to find percentage of null values in a table
SQL
0 vote181 views1 answer
Import all databases mysql
SQL
4 votes208 views3 answers
Sql drop database if exists
SQL
0 vote204 views1 answer
Join creating duplicate columns sqllite
SQL