CONCAT
Syntax
<ceil-expression> := 'CONCAT(' <String> [ ',' <String> ] ')'
Since
2.0
Return-type
String
Description
The function CONCAT concatenates all strings from argument one to one string, using the delimiter defined with the optional second argument. If no delimiter is defined, the standard-delimiter "," is used.
If the first argument is NULL, this function returns NULL.
Examples
CONCAT( LEVEL( Customer, 1 ).Name )
E.g. returns 'Customer1,Customer2,Customer3'
CONCAT( LEVEL( Customer, 1 ).Name, ';' )
E.g. returns 'Customer1;Customer2;Customer3'
See also
ADD
