version 11
CONCAT (arithmetic_expression, arithmetic_expression)
Description
The CONCAT function returns the two arithmetic_expression type arguments passed as a single concatenated string.
Example
This example will return the first name and last name as a single string:
SELECT CONCAT(CONCAT(PEOPLE.FirstName,' '), PEOPLE.LastName) FROM PERSONS;
See Also