SQL Server Concat with +
THE WORLD'S LARGEST WEB DEVELOPER SITE
HTML CSS JAVASCRIPT SQL PHP BOOTSTRAP HOW TO JQUERY W3.CSS ANGULAR XML MORE FORUM EXAMPLES REFERENCES

SQL Server Concat With +

❮ SQL Server Functions

Example

Concatenate strings together:

SELECT 'W3Schools' + '.com';
Try it Yourself »

Definition and Usage

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

Note: See also the CONCAT() function.

Syntax

string1 + string2 + string_n

Parameter Values

Parameter Description
string1, string2, string_n Required. The strings to concatenate

Technical Details

Works in: SQL Server 2014, SQL Server 2012, SQL Server 2008 R2, SQL Server 2008, SQL Server 2005

More Examples

Example

Concatenate strings together:

SELECT 'SQL' + ' is' + ' fun!';
Try it Yourself »

Example

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

SELECT 'SQL' + ' ' + 'is' + ' ' + 'fun!';
Try it Yourself »

❮ SQL Server Functions