XQuery: Return value of an element rather the element itself

Question

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 1

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()

Answer 2

Use the string function to get the string content of a node.

return string($xml)

Answer 3

To return only the data inside an element you can use:

return data($xml)

Answer 4

Cast to xs:string {xs:string($xml/foo)}

Answer 5

OSB (oracle service bus) users can use following function.

fn-bea:serialize($xml)