XMLCONCAT
The XMLCONCAT function concatenates one or more XML fragments.
Syntax
XMLCONCAT ( <XML value expression> { , <XML value expression> }...
[ <XML returning clause> ] )
Remarks
• If an argument evaluates to NULL, that argument is ignored.
• If all arguments are NULL, the result is NULL.
• If only one non-NULL argument is supplied, the result of the function is that argument.
Example
SELECT XMLCONCAT (XMLTEXT (customers.ContactFirstName), XMLTEXT (' '),
XMLTEXT (customers.ContactLastName)) AS CustomerName
FROM /shared/examples/ds_orders/customers customers