CONCAT

Concatenates two or more strings. NULL values are ignored.

Syntax

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

• expression1: First string expression.

• expression2: Second string expression.

• expressionN: Nth string expression.

Examples

CONCAT example

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

CONCAT example

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