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