I have a text column named bid_xml in my table which has the following value:
Code:
<?xml version=1.0 encoding=UTF-8?>
<dpid:DpidDatabase xmlns:dpid=http://ddex.net/xml/dpid/11 xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance xsi:schemaLocation=http://ddex.net/xml/dpid/11 http://ddex.net/xml/dpid/11/dpid.xsd>
 <DpidOwner SequenceNumber=1>
  <DPID>PADPIDA2006111001O</DPID>
  <CompanyName>234AG</CompanyName>
...