Skip to main content
Version: current [24.3.x]

CONCAT

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 (optional): Second string expression.
  • expressionN (optional): Nth string expression.

Examples

CONCAT example
SELECT CONCAT('CON', 'CAT')
-- CONCAT
CONCAT example
SELECT CONCAT('con', 'cat', NULL)
-- concat