Loading lesson path
Concept visual
Start at both ends
CONCAT('W3Schools', '.com');The CONCAT() function adds two or more strings together.
Formula
Concat with the + operator andCONCAT_WS().
string1, string2,...., string_n )
Description string1, string2, string_n Required. The strings to add together
SQL Server (starting with 2012), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse
CONCAT('SQL', ' is', ' fun!');Add strings together (separate each string with a space character):
CONCAT('SQL', ' ', 'is', ' ', 'fun!');❮ SQL Server Functions