I have a report made using SQL reporting services and one of the value is a xml. I would like to remove all tags and keep only the content.for example\[code\]<Test>Hello</Test><Whatever ID=5>World</Whatever>\[/code\]Would simple returns HelloWorld.Is there a way to do such things ? If it's in SQL that would work too.Thanks