Can someone help me Query this

Jun 29 2020 3:48 PM

I have 3 columns(with data types are STRING(varchar)) in a table by name bondId,bondName and BondXMLinfo


below is the sample of one of the BondXMLinfo columns


<PS1:ComapnyInfo xmlns:PS1="http://schemas.datacontract.org/2004/07/Shared.ViewModels.Warehouse"><PS1:AccountBillingNumber xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/>
<PS1:AccountNumber>1017412</PS1:AccountNumber>
<PS1:AgencyAddress1>PO Box 19150</PS1:AgencyAddress1>
<PS1:AgencyAddress2>1333 S Rustle Rd.</PS1:AgencyAddress2>
<PS1:AgencyCity>Spokane</PS1:AgencyCity>
<PS1:AgencyCode>88229</PS1:AgencyCode>
<PS1:AgencyCompany>Cochrane and Company</PS1:AgencyCompany>
<PS1:ExpDate>2020-05-06T00:00:00</PS1:AgencyCountry>
</PS1:CompanyInfo>

I want the output as bondId, bondName and ExpDate from the BondXMLinfo columns


Brought to you by: JavaScript SDK for Bold BI dashboard and analytics embedding. Free trial.

Answers (1)