XQuery string-join Function

How to use the XQuery string-join() function to concatenate string sequences with custom delimiters for XML data processing.

The string-join function is used to concatenate various sequences separated by a given delimiter.

Syntax

string-join($sequence as xs:string*, $delimiter as xs:string) as xs:string

Input Parameters

$sequence: sequence of zero or more strings.
$delimiter: delimiter to separate the items of above sequence.

Example

XQuery Expressionxquery

let $fruits :=
<fruits>
   <fruit>Apple</fruit>
   <fruit>Orange</fruit>
   <fruit>Guava</fruit>
   <fruit>Pinapple</fruit>
</fruits>

return
<results>
   <fruits>{
      string-join($fruits/fruit, ',')
   }</fruits>
</results>

Outputxml

<results>
   <fruits>Apple,Orange,Guava,Pinapple</fruits>
</results>