I'd stay away from the plus sign for concatenations as a practice. Although it will work in the example given it can cause a type mis-match error with numerics. That's just my way and that doesn't make it right. This will cause an error (lngValue can probably be wrapped to make it work but why deal with that):

Code:
Dim strsql As String
Dim lngValue As Long

lngValue = 10

strsql = "Select * from TableName where Value = " + lngValue