CONCAT

The CONCAT function combines two arguments.

Read syntax diagramSkip visual syntax diagramCONCAT (expression-1,expression-2)

The arguments must be compatible. For more information about data type compatibility, see Assignments and comparisons.

expression-1
Start of changeAn expression that returns a value of any built-in numeric, datetime, or string data type. A numeric or datetime argument is cast to a character string before evaluating the function. For more information about converting numeric or datetime to a character string, see VARCHAR.End of change
expression-2
Start of changeAn expression that returns a value of any built-in numeric, datetime, or string data type. A numeric or datetime argument is cast to a character string before evaluating the function. For more information about converting numeric or datetime to a character string, see VARCHAR.End of change

The result of the function is a string that consists of the first argument string followed by the second. The data type of the result is determined by the data types of the arguments. For more information, see With the concatenation operator. If either argument can be null, the result can be null; if either argument is null, the result is the null value.

Note

Syntax alternatives: The CONCAT function is identical to the CONCAT operator. For more information, see With the concatenation operator.

Example

  • Concatenate the column FIRSTNME with the column LASTNAME. 
      SELECT CONCAT(FIRSTNME, LASTNAME)
    FROM EMPLOYEE
    WHERE EMPNO ='000010'
    Returns the value 'CHRISTINEHAAS'.