http://www.sqlservercentral.com/blogs/prosqlxml/archive/tags/URI/default.aspxTags: URIenCommunityServer 2007.1 (Build: 20917.1142)http://www.sqlservercentral.com/blogs/prosqlxml/archive/2008/03/09/grabbing-node-names-and-values-pt-2.aspxSun, 09 Mar 2008 05:55:00 GMT70975365-724d-4ce8-8d1c-45c963ab81ff:8689Michael Coles0http://www.sqlservercentral.com/blogs/prosqlxml/rsscomments.aspx?PostID=8689http://www.sqlservercentral.com/blogs/prosqlxml/commentapi.aspx?PostID=8689http://www.sqlservercentral.com/blogs/prosqlxml/archive/2008/03/09/grabbing-node-names-and-values-pt-2.aspx#commentsAs a follow-up to my last post on grabbing node names and values , I was asked about grabbing URIs from more complex XML documents. The following query is the result of that discussion: DECLARE @x xml ; SET @x = N &#39;&lt;?xml version = &quot;1.0&quot;...(<a href="http://www.sqlservercentral.com/blogs/prosqlxml/archive/2008/03/09/grabbing-node-names-and-values-pt-2.aspx">read more</a>)<img src="http://www.sqlservercentral.com/blogs/aggbug.aspx?PostID=8689" width="1" height="1">XMLSQL ServerXQueryfunctionURInamespaces