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.
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.
Syntax alternatives: The CONCAT function is identical to the CONCAT operator. For more information, see With the concatenation operator.
SELECT CONCAT(FIRSTNME, LASTNAME) FROM EMPLOYEE WHERE EMPNO ='000010'Returns the value 'CHRISTINEHAAS'.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.