Returns a character string that is the result of concatenating string_exp2 to string_exp1.

 

Example:

SELECT CONCAT('ABCDEFG','HIJKLMN') returns ABCDEFGHIJKLMN