Description
Concatenates a variable number of strings and returns them as one string.
Syntax
CONCAT(string_expression1, string_expression2[…, string_expressionN])
Examples
CONCAT('username','@xyzmail.com') returns 'username@xyzmail.com'
Return value datatype
String
Impact of null value
If input is null, returns null.