A link to a blog that can be used as the starting point for those who need to manipulate XML held in MS-SQL.
http://beyondrelational.com