Scalar. Extracts the value of an XML element tree that matches a given XPATH expression.
If value is Null, XMLEXTRACTVALUE returns Null. If the XPATH comparison returns more than one possible value, Sybase CEP Engine returns the first value and issues a warning that other values were found.
XMLEXTRACT
XMLTABLE Expressions in the FROM Clause
The following example shows an extraction of all "items" element nodes:
INSERT INTO OutStream SELECT XMLEXTRACTVALUE(OrderVal1,'//items') FROM Orders;