bugl
bugl
HomeLearnPatternsSearch
HomeLearnPatternsSearch

Loading lesson path

Learn/SQL/SQL References
SQL•SQL References

SQL Server Concat With +

Concept visual

SQL Server Concat With +

Pointer walk
two pointers
leftright102132436485116
left=0
right=6
1
3

Start at both ends

Example

Add 2 strings together:

Select

'W3Schools' + '.com';

Definition and Usage

Formula

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

Note:

See also the CONCAT()

and CONCAT_WS() functions. Syntax string1 +

Formula

string2 + string_n

Parameter Values

Parameter

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

Technical Details

Works in:

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

More Examples

Example

Add 3 strings together:

Select

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

Example

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

Select

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

Previous

❮ SQL Server Functions

Next

Previous

SQL Server CONCAT() Function

Next

SQL Server CONCAT_WS() Function