Text strings concatenation “&” or “+”

[PWise]

Text strings concatenation “&” or “+”
What is the difference what you use for text strings concatenation “&” or “+”?

 

[randysmid]

Hi,
Microsoft recommends using the ampersand character for string concatenations.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/html/vsopradd.asp

HTH,
Randy Smith
California Teachers Association

 

[chrissie1]

NOrmally you use & in VBA code but in T-SQL you use the + sign

 

[PWise]

Thanks everyone
randysmid:
Following your lead for the + operator and from there to the & operator
I see that the difference is that with the + operator if one value is null the result is null
“Hello” + null + “ everyone” = null
but with the & operator the result is the rest of the string
“Hello” & null & “ everyone” = “Hello everyone”