CONCAT

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.