title: How to remove an <i> tag with a certain value from XML List through SQL Statement (Microsoft SQL Server Management Studio)
body: <p>I have a simple XML List, which looks like this:</p>
  
  <pre><code>&lt;i&gt;8&lt;/i&gt;
  &lt;i&gt;20&lt;/i&gt;
  &lt;i&gt;24&lt;/i&gt;
  </code></pre>
  
  <p>For this example I want to remove the 2nd Node from this List.</p>
  
  <p>How do I do that?</p>
  
  <pre><code>DECLARE @xml XML;
  
  SET @xml = &lt;i&gt;8&lt;/i&gt;&lt;i&gt;20&lt;/i&gt;&lt;i&gt;24&lt;/i&gt;
  
  SELECT @xml.modify('delete &lt;i&gt;20&lt;/i&gt;')
  </code></pre>
  
  <p>Thank you!</p>