Returns a character string that is the result of concatenating string_exp2 to string_exp1.
Note - the || operator may also be used to concatenate two values.

 

Example:

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

SELECT 'ABCDEFG' || 'HIJKLMN' returns ABCDEFGHIJKLMN