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'.


