What exactly do you want to extract?
A simple SELECT columns FROM table will give you the content of the table.
If you want to shred the XML data you should look into XQuery.
For more details please provide sample data and expected results in a ready to use format.
Lutz
A pessimist is an optimist with experience. How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]