XQuery string-join Function

XQuery string-join Function

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 Expression

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>

Output

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