SQL CONCAT Function

The SQL CONCAT one of the SQL String Function, which is used to combine two or more strings and returns string.

TIP: Unlike + Operator CONCAT Function will convert Null values into Empty string while displaying the result.

SQL CONCAT Function Syntax

The basic syntax of the CONCAT Function in SQL Server is as shown below:

In this article we will show you, How to write Concat Function in SQL Server 2014 with example. For this, We are going to use the below shown data

SQL CONCAT Function Example 1

The SQL String CONCAT Function simply returns the string by combining two or more strings. The following query will show multiple ways to use Concat function.

T-SQL CODE

OUTPUT

ANALYSIS

Below lines of code is used to declare two string variables and assigning them some data.

Below statement, Concat function will combine the two variable and produce the string result. We also assigned new name to that result as ‘SQL Contact’ using SQL ALIAS Column.

In the next line, We used Concat function to combine the three string values directly

SQL CONCAT Function Example 2

The CONCAT function also allows you to combine multiple columns. In this example,We are going combine the First name and Last Name columns present in the Employe column to get Full name.

T-SQL CODE

OUTPUT

TIP: We used this ‘  ‘ to get empty space. If you want comma or something just replace empty space with comma

SQL STRING CONCAT Function Example 3

The CONCAT function also allows you to combine columns and string text in one statement. In this example,We are going combine the First name, Last Name and Department name columns present in the Employe column and string text = ‘is working as’.

T-SQL CODE

OUTPUT

Thank You for Visiting Our Blog