I did a slight modification

select @xml = cast(( '') as xml)

SELECT N.value('.', 'nvarchar(max)')

so if there are tags in the string it handles them