I have the below table Person
Name
Place
XML Info
Tom
USA
<PersonInfo>
<Name>Tom</Name>
<Age>20</Age>
<Sex>M</Sex>
</PersonInfo>
Dick
UK
<Name>Dick</Name>
<Age>21</Age>
Hary
AUS
<Name>Hary</Name>
<Age>22</Age>
I want one big XML as output(in one column) without connectors like ‘+’ or commas
Select xml Info from Person
<PersonInfo><Name>Tom</Name><Age>20</Age><Sex>M</Sex></PersonInfo><PersonInfo><Name>Dick</Name><Age>21</Age><Sex>M</Sex></PersonInfo><PersonInfo><Name>Hary</Name><Age>22</Age><Sex>M</Sex></PersonInfo>