Concatenation operator in DataWindow expressions

The concatenation operator joins the contents of two variables of the same type to form a longer value. You can concatenate strings and blobs.

To concatenate values, you use the plus sign (+) operator.

Table 1-11: Using expressions with concatenation operator

String expression

Value

"over" + "stock"

overstock

Lname + ', ' + Fname

If Lname is Hill and Fname is Craig, then "Hill, Craig"

NoteUsing quotes You can use either single or double quotes in string expressions. For example, the expression “over” + “stock” is equivalent to the expression 'over' + 'stock'.