+ (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>