CONCAT
Description
CONCAT
is a row function that returns a TEXT
by concatenating (combining together) the results of multiple TEXT
expressions.Syntax
CONCAT
(value_expression
[,value_expression
][,...])Return Value
Returns one value per row of type
TEXT
.Input Parameters
- value_expression
- At least one required. A field name of any type, a literal string or number, or an expression that returns any value.
Examples
Combine the values of the
month
, day
, and year
fields into a single date field formatted as MM/DD/YYYY
.CONCAT([month], "/", [day], "/", [year])