title: Retrieve first value with Xquery using a wildcard
body: <p>In an XmlData column in SQL Server 2008 that has no schema assigned to it, how can I pull the first item at a particular node level?  For example, I have: </p>
  
  <pre><code>SELECT 
  XmlData.value('//*/*[1]','NVARCHAR(6)')
  FROM table
  where XmlData.Exist('//*/*[1]') = 1
  </code></pre>
  
  <p>I assume this does not work because if there are multiple nodes with different names at the 2nd level, the first of each of those could be returned (and the <code>value()</code> requires that a singleton be selected. 
  Since I don't know what the names of any nodes will be, is there a way to always select whatever the first node is at the 2nd level?</p>