mickygreener
New Member
A while ago I asked this question:http://stackoverflow.com/questions/12086720/tsql-for-xml-xml-tag-just-onceorhttp://blogs.msdn.com/b/denisruc/archive/2006/05/17/600250.aspxI wrote "$$" in each potential empty tag and at the end I tried to remove all the tags with "$$" with:\[code\]SET @persons.modify('delete (//$$)')\[/code\]But it does not work this way.How can I remove empty- and self-closing tags with XQuery or prevent them to appear within TSQL for xml?