title: How to use sql function for a computed column to retrieve a value from XML
body: <p>I have a table with a <code>XML</code> column and save XML like this to it:</p>
  
  <pre><code>&lt;Employees&gt;
      &lt;Person&gt;
          &lt;ID&gt;1000&lt;/ID&gt;
          &lt;Name&gt;Nima&lt;/Name&gt;
          &lt;LName&gt;Agha&lt;/LName&gt;
      &lt;/Person&gt;   
  &lt;/Employees&gt;
  </code></pre>
  
  <p>I want to have another table with a columns that in it I use a function to retrieve value of <code>Name</code> element from every row.such this :</p>
  
  <pre><code>  Id           Name
    -----------------
    1            Nima
    2            Agha
    ...          ...
  </code></pre>
  
  <p>How I can do this?</p>
  
  <p>thanks</p>