&

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"