Concat

Table of Contents

Overview
Prototype

Example

See also
Related

Concatenates all of the given values that are not null. Accepts any number of values. The + operator can also be used to concatenate, but a null on either side of + makes the whole result null.

Prototype

String Concat(StringInfinite text)

Example

Joins three values.

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