+ (String Concatenation) (TSQL Operator)
Concatenates two strings.
Syntax
expression + expression
Arguments
- expression
- is an expression of type
varchar
.
Return Types
Returns varchar
.
Remarks
If any expression is NULL, the result is NULL.
To concatenate expressions that can be NULL, use CONCAT
.
Examples
PRINT 'Hello' + 'World';
PRINT 'Hello' + NULL;
The result is:
HelloWorld
<NULL>