I am getting

Col

----

<?xml version="1.0" encoding="UTF-8"?><asdf>woot</asdf> in a string when I am trying to convert it into XML like select CONVERT(XML,'<?xml version="1.0" encoding="UTF-8"?>' + cast(@xml as varchar(max)))

Getting only

Col

----

<asdf>woot</asdf>

What...

getting with your query like

(No column name)

<asdf>woot</asdf>

But I need like

<?xml version="1.0" encoding="UTF-8"?>

<asdf>woot</asdf>

For Exp: I have the row data lengthy like "aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa"

I need to display that data in Card in Power View, I able display as it is

but I need like...

For Exp: I have the row data lengthy like "aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa"

I need to display that data in Card in Power View, I able display as it is

but I need like...