&
Purpose
Used to force string concatenation of two expressions.
Syntax
expression1 & expression2
Description
Whenever an expression is not a string, it is converted to a String subtype. If both expressions are Null, then the result is also Null. However, if only one expression is Null, that expression is treated as a zero-length string ("") when concatenated with the other expression. Any expression that is empty is also treated as a zero-length string.
Examples
Function | Result |
---|---|
"Today's date is " & DateTime() | "Today's date is 01/03/2012" |
1 & NULL | "1" |
"01-03-2012" & 01-03-2014 | "01-03-2012-2014" |