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