CONCAT(Str1, Str2)

String Expression

Returns the concatenation of Strings Str1 and Str2.

Example: CONCAT("Dallas",CONCAT(", ","TX")) returns "Dallas, TX"