bugl
bugl
HomeLearnPatternsPathsSearchPremium
HomeLearnPatternsPaths

Loading lesson path

Learn/SQL/SQL References
SQL•SQL References

SQL Server Concat With +

Example

SELECT
'ExampleSite' + '.com';

Definition and Usage

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

Note

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

Syntax

string1 +
 string2 + string_n

Parameter Values

ParameterDescription
string1, string2, string_nRequired. The strings to add together

Technical Details

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

Previous

SQL Server CONCAT() Function

Next

SQL Server CONCAT_WS() Function