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])