Using XQuery in SQL 2005 to replace a node's value?

You can manipulate the XML variable directly and perform the replacement: set @xmldata. Modify('replace value of (/Collection/Plan/Type/text())1 with "new value"') select @xml (The XPath might not be exactly correct as I don't have access to a sql server atm) Also, note that this won't work if UNKNOWN is actually empty text, that requires a bit more work! ).

Thank you very much! – Darth Continent Jun 13 '09 at 14:39 what is the workaround in the edge case you mention (empty text) – paulwhit Aug 31 '09 at 20:06.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.