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 vote256 views1 answer
How to see the query of a view in mysql
SQL
0 vote233 views1 answer
Mysql convert column to uppercase
SQL
0 vote258 views1 answer
How to insert same table data using mysql query
SQL
12 votes279 views4 answers
Mysql ifnull
SQL
0 vote330 views1 answer
Postgres rename database
SQL
2 votes261 views1 answer
Insert from table tsql
SQL
0 vote313 views2 answers
Impala rename column name
SQL
0 vote321 views1 answer
Copy from one table to another postgres using matching column
SQL
0 vote318 views1 answer
Postgres list tables and row counts
SQL
0 vote262 views1 answer
Django mysqlclient connection string
SQL