As I mentioned previously, AFAIK, there is no real way to just strip out a namespace from an xml structure by using TSQL other than to cast the xml to a varchar(max) and hack it out by using REPLACE(). But as shown, working with xml namespaces is relatively straight forward....