MKSTRING
Deprecated version
This document refers to a deprecated version of the RQL programming language.
Please go here for documentation related to the latest supported version.
Merges a collection of strings into a single string, with a separator. Null strings are skipped. Null collections lead to a null result.
MKSTRING
can be applied any expression, for example a SELECT
statement evaluating to a collection of strings.
Syntax
MKSTRING(<collection of strings>, <separator string>)
Example
MKSTRING(["string1", "string2"], " - ") // "string1 - string2"
MKSTRING(["string1"], " - ") // "string1"
MKSTRING(["12", null, "34"], ";") // "12;34"
MKSTRING(countries UNION ALL cities, ";")
MKSTRING((SELECT name FROM people), ";")
caution
Keep in mind the possibility of a parser ambiguity when passing a complex
expression as a parameter to MKSTRING
: in the example above parenthesis are required.