Concatenate (x & y) and Concatenate (x
+ y) are synonymous if both operands x and y are strings.
Usage
x & y
Concatenates the values of x and y, and
returns the result as a String. x and y can be of one of the types Number,
Boolean, Currency, Date, Time, DateTime, and String.
Examples
10 & 20
Returns the String "10.0000020.00000",
where the number formatting for this formula field specifies 5 decimal places.
Use the Cstr function if you want to specify how to format a String when
converting from a different type. In this example, you can use CStr on the
Number values a and b to convert and format each of them to a String, and then
concatenate the resultant Strings.
True & False
Returns the String "TrueFalse".
"The meeting is " & #Nov 15. 1999#
Returns the String "The meeting is
11/15/99 12:00:00 AM".
"Boy" & "Girl"
Returns the String "BoyGirl".
Comments
The format of the returned value is
determined by the format that has been set up for that formula field of the
corresponding type of operands. However, if you want to convert to a String
from a value of a different type and be able to specify formatting for the
resultant string, you can use the Cstr function.