Skip to main content

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