Hi All,
I am working with the SQL tables that has XML data stored in a field defined as varchar. I am trying to extract specific element from the XML and this is what I have so far:
select XMLInString, CAST(XMLInString as XML),
CAST(XMLInString as XML).query('/pbXML/Shipment/BillNr[1]')
from ShipmentPlanning
This almost works. 3rd field in the above query returns: BillNr 9999 /BillNr
What I am looking for is only the 9999 part to be returned.
Thank you,
daniel