You can just cast the nvarchar column to xml, but this obviously incurs the overhead of parsing the content and would error out if the column contains invalid xml.

use tempdb;

create table t (i int, x nvarchar(100));

insert t values (1, '<abc>def</abc>');

go

select i, cast(x as xml) from t for xml auto

go