CONCAT

Returns a concatenated string. The two arguments must be compatible strings.

Example:

Concatenate the column FIRSTNME with the column LASTNAME.

  CONCAT(FIRSTNME, LASTNAME)