THE WORLD'S LARGEST WEB DEVELOPER SITE

SQL Server CONCAT() Function

❮ SQL Server Functions

Example

Add two strings together:

SELECT CONCAT('W3Schools', '.com');
Try it Yourself »

Definition and Usage

The CONCAT() function adds two or more strings together.

Note: See also Concat with the + operator and CONCAT_WS().

Syntax

CONCAT(string1, 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 2012), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse

More Examples

Example

Add 3 strings together:

SELECT CONCAT('SQL', ' is', ' fun!');
Try it Yourself »

Example

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

SELECT CONCAT('SQL', ' ', 'is', ' ', 'fun!');
Try it Yourself »

❮ SQL Server Functions