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.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |