On every site that talks about VBScript, the '&
' operator is listed as the string concatenation operator. However, in some code that I have recently inherited, I see the '+
' operator being used and I am not seeing any errors as a result of this. Is this an accepted alternative?

- 2,404
- 3
- 25
- 30
4 Answers
The &
operator does string concatenation, that is, forces operands to be converted to strings (like calling CStr
on them first). +
, in its turn, forces addition if one of the expressions is numeric. For example:
1 & 2
gives you 12
, whereas
1 + 2
"1" + 2
1 + "2"
give you 3
.
So, it is recommended to use &
for string concatenation since it eliminates ambiguity.

- 87,344
- 17
- 243
- 314
-
7+1 for specifying string number + number. Accepted answer doesn't mention vbscript converting numeric strings to numbers. – baacke Jan 21 '14 at 17:22
The + operator is overloaded, whereas the & operator is not. The & operator only does string concatenation. In some circles the & operator is used as a best practice because it is unambiguous, and therefore cannot have any unintended effects as a result of the overloading.

- 178,213
- 47
- 333
- 501
-
-
6@wolf in VB the + operator can do both addition and concatenation, depending on context. – Robert Harvey Dec 08 '16 at 15:32
-
1Well, I already read this. I found the word *overloaded* itself so overloaded that I wished, the answer could be a little bit more precise in this point. – Wolf Dec 08 '16 at 23:00
+
operator might backfire when strings can be interpreted as numbers. If you don't want nasty surprises use & to concatenate strings.

- 12,811
- 4
- 46
- 62
In some cases the + will throw an exception; for example the following:
Sub SimpleObject_FloatPropertyChanging(fvalue, cancel)
'fvalue is a floating point number
MsgBox "Received Event: " + fvalue
End Sub
You will get an exception when the COM object source fires the event - you must do either of the following:
MsgBox "Received Event: " & fvalue
or
MsgBox "Received Event: " + CStr(fvalue)
It may be best in either case to use CStr(value)
; but using & per above comments for string concatenation is almost always best practice.

- 8,598
- 83
- 57
- 92

- 648
- 6
- 21