In this article, we will learn how to Concat columns in SQL.

Below is a selection from the “tblEmployees” table:

SELECT * FROM tblEmployees;

  • Using CONCAT() function:

The string function, CONCAT() is used to add two or more strings together.

Please check How To Use String Functions In SQL, to get understand other SQL string functions.

SELECT CONCAT(EmpName, ', $', Salary) AS NameSalary 
FROM tblEmployees;
  • Without using CONCAT() function:
SELECT EmpName + ', $' + CONVERT (VARCHAR, Salary) AS NameSalary 
FROM tblEmployees;


Both methods return the same output.

Also, check How To Use Server Profiler In SQL


Select Categories