XMLCONCAT()

Scalar. Concatenates XML expressions.

Syntax

XMLCONCAT( expression, expression [, ...])

Parameter
expression	An expression that evaluates to an XML value. Ignored if Null. If a sequence of XML trees, Sybase CEP Engine concatenates each element tree in order.

Data Types
Return	expression
XML	XML

The following example shows concatenation of two XML elements:

INSERT INTO OutStream 
SELECT XMLCONCAT(XMLELEMENT("name", orders.customerName),
    XMLELEMENT("city", orders.customerCity)) 
FROM Orders;