Test for a specific node value in an XML column including potentially empty nodes

http://stackoverflow.com/questions/5278092/how-to-check-that-the-xml-element-has-the-attribute-with-an-empty-string-value

TSQL query for tree view control and remove empty elements from an xml file

http://stackoverflow.com/questions/12296869/tsql-query-for-tree-view-control-and-remove-empty-elements-from-an-xml-file

SQL 2008: Insert XML value with backslash-doublequote combo

http://stackoverflow.com/questions/5656863/sql-2008-insert-xml-value-with-backslash-doublequote-combo