We have a weirdo system we're integrating with which consumes XML, but it does not understand self-closing tags, so
<BOOKING> <BOOKINGID>56812</BOOKINGID> <PERSONCODE /> </BOOKING>
is beyond its capabilities.
If what I have is
declare @x xml, how do I convert that
@x to string without having self-closing tags:
<BOOKING> <BOOKINGID>56812</BOOKINGID> <PERSONCODE></PERSONCODE> </BOOKING>