CONCAT Function in SQL Server: What You Need to Know

The article will explore and show you how to use the CONCAT () function in SQL Server to join multiple strings into a string.

Describe

The CONCAT function in SQL Server helps join two or more strings into a single large string.

Syntax

To run the CONCAT function in SQL Server, we use the following syntax:

 CONCAT(chuoi1, chuoi2,. chuoi_n) 

Parameters :

• series1, chuoi2,. cycle : strings want to connect with each other.

Note :

• Input CONCAT function has a maximum length of 255 strings, a minimum of 2 strings. If only one input string is passed, CONCAT will generate an error.
• If passing strings without characters, CONCAT will automatically convert those values into strings before joining.
• The CONCAT function converts NULL to an empty string in VARCHAR data type (1).
• The CONCAT function can only be used in later versions of SQL Server: SQL Server 2017, SQL Server 2016, SQL Server 2014, and SQL Server 2012.

For instance,

Take a look and explore some examples of CONCAT functions in SQL Server.

 SELECT CONCAT('Tipsmake', '.com'); 
 Result: 'TipsMake.com' 
 
 SELECT CONCAT('Quan', 'tri', 'mang', '.com'); 
 Result: 'TipsMake.com' 
 
 SELECT CONCAT('Quan ', 'Tri ', 'Mang '); 
 Result: 'Tipsmake' 

When combining strings together, you can add whitespace characters to separate your linked values for easier reading.

 SELECT CONCAT('Orange', ' ', 'Peach', ' ', 'Apple'); 
 Result: 'Orange Peach Apple' 

Next lesson: '+' operator in SQL Server