XQuery: Return value of an element rather the element itself
I have an XML document that contains the following
...
<foo>abc</foo>
...
If I evaluate
return $xml//foo
I get back
<foo>abc</foo>
Is there any way to get just abc instead?
Answer
Yes, you want the text() function for selecting the child text:
return $xml/text()
Be careful if you will have nested tag structure inside $xml though, because this will only go one level deep for text nodes. If you want all of the text nodes together, stripping out other XML structure, this will do arbitrarily deep:
return $xml//text()