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.