SQL Server Concat With +

Add 2 strings together:

SELECT 'W3Schools' + '.com';

Definition and Usage

The + operator allows you to add two or more strings together.

Note: See also the CONCAT() and CONCAT_WS() functions.

string1 + string2 + string_n

Parameter	Description
string1, string2, string_n	Required. The strings to add together

Works in:	SQL Server (starting with 2005), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse

Add 3 strings together:

SELECT 'SQL' + ' is' + ' fun!';

Add strings together (separate each string with a space character):

SELECT 'SQL' + ' ' + 'is' + ' ' + 'fun!';