The XMLCONCAT function creates a forest of XML elements by concatenating all the XML values passed in. For example, the following query concatenates the <given_name> and <surname> elements for each employee in the Employees table:
SELECT XMLCONCAT( XMLELEMENT( NAME given_name, GivenName ), XMLELEMENT( NAME surname, Surname ) ) AS "Employee_Name" FROM Employees; |
This query returns the following result:
Employee_Name | ||
---|---|---|
|
||
|
||
|
||
|
||
... |
For more information, see XMLCONCAT function [String].
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |