title: Check if XML nodes are empty in SQL
body: <p>Hi I am new to XML manipulation, my question would be if there is a possibility of detecting if the XML node is an empty node like this: <code>&lt;gen:nodeName /&gt;</code></p>
  
  <p>I am able to manipulate single nodes however I would be interested if there is an approach like a loop or recursive function that could save some time doing manual labor looking trough every single node. I have no idea how to approach this problem though. </p>
  
  <p>Thanks for help.</p>