I'm trying to parse out nodes from an XML string, which is saved in a txt field in my sql database. I am not experiences w/ XML data files btw.
The string doesn't start at the root and the field isn't type xml.
Attached is an picture of the text field with the elements I'd like to query out:
For example; I'd like to be able to pull <PitchType> from the records starting with <PitchPush>.
I've tried cross apply XML_Data.notes(...) and as the field isn't a type xml it errors.
I've seen methods that use the namespace, or refer to 'if you have the root'; neither of which are the case for my data.
Are there methods for this? If necessary I'm willing to pull the strings into a csv & import to temp table. This data will be static when (if) I can get to it.