Concat

The concat function merges or concatenates the values of text fields from documents within a specified schema. It's used with the SELECT statement to combine the text values of the designated fields across the documents within the schema.


String Concat(String text, ...)


Selects documents from the FlatTranslate schema and concatenates (or appends) the three values.

SELECT
    Concat(English, '->', German)
FROM
    WordList:FlatTranslate
WHERE
    English LIKE 'Cat%'

• Scalar Functions