Categories: String

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

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

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