Remove XML formating in a report

nothing

New Member
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
 
Back
Top