CONCAT

Click to skip syntax diagram
Read syntax diagramSkip visual syntax diagram>>-CONCAT--(--expression--,--expression--)---------------------><
 

The CONCAT function combines two arguments.

The arguments must be compatible. Character-string arguments are not compatible with datetime values. For more information about data type compatibility, see Assignments and comparisons.

expression
The argument must be an expression that returns a value of any built-in numeric or string data type. A numeric argument is cast to a character string before evaluating the function. For more information on converting numeric to a character string, see VARCHAR.

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