convert varchar to xml in sql server

Here is a small code snippet to convert you varchar data to XML data

declare @data varchar(100) set @data ='



select convert(xml,@data)
 
 
The data will be converted into XML.
 
Cheers,
Venkatesan Prabu .J