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.
String expression |
Value |
---|---|
"over" + "stock" |
overstock |
Lname + ', ' + Fname |
If Lname is Hill and Fname is Craig, then "Hill, Craig" |
Using 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'.