How to select the data from xml

This post was flagged by the community and is temporarily hidden.

Polo,
you can't just dump text in here and expect a reasonable response. Can you post a sample of what the data looks like and what you expect as a result.

I.E.
Declare @x xml = 'XML data'

and then expected results