Concat

Table of Contents


Overview
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.

Prototype
String Concat(String text, ...)

Example
round-pushpin Selects documents from the FlatTranslate schema and concatenates (or appends) the three values. 
SELECT
    Concat(English, '->', German)
FROM
    WordList:FlatTranslate
WHERE
    English LIKE 'Cat%'

See also

Related