concat.md

description
Concatenates two or more strings. NULL values are ignored.

CONCAT

Syntax

CONCAT(expression1 string, expression2 string, expressionN string) → string

• expression1: First string expression.
• expression2: Second string expression.
• expressionN: Nth string expression.

Examples

{% code title="CONCAT example" %}

SELECT CONCAT('CON', 'CAT')
-- CONCAT

{% endcode %}

{% code title="CONCAT example" %}

SELECT CONCAT('con', 'cat', NULL)
-- concat

{% endcode %}