Skip to main content
Version: 0.0.1

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

{{< codeheader "CONCAT example" >}}

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

{{< codeheader "CONCAT example" >}}

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