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