CONCAT

​

Syntax

​

Scalar

concat(value, ...)

​

Arguments

​

Returns

• Type: STRING
• Possible values: The strings joined without a separator.
• NULL behavior: Returns NULL if any argument is NULL.

​

Properties

​

Examples

​

Typical behavior

SELECT concat('a', 'b') AS joined, concat('a', CAST(NULL AS STRING)) AS null_input;

​

Empty text and Unicode text

SELECT concat('', 'cat') AS with_empty_string, concat('é', '猫') AS unicode_text;

​

Limitations

• Supply one or more STRING arguments. If any argument is NULL, the result is NULL; NULL arguments are not skipped.