If the xml file was valid, how would you search for CompanyCode within the XML which is a text column? just want to know the systax for XML).query(???? please

Please find the xml file attachmed. Cheers

want to return NxxxxqM from node CompanyCode

currently I am doing this using charindex and substring.

Hi Barry,

I am trying to query SQL Server 2005 table column which is text type and contains XML Message

The following is an example of the XML message:

...