Here's the general idea:
SELECT Id, Name, Whatever, myxml from MyTable;
FROM FIELD (Rawdata, myxml) (XmlSimple, Table is [foo]);
The easiest way to generate the "blah" and "foo" bits is to save one of the "myxml" rows in an xml file and use the table files wizard to generate the xml load statement.
If the values in your xml column don't have an enclosing element, then you may need to fake one in as shown in this thread.