How To Concat Columns In SQL

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;

Output

Both methods return the same output.

Also, check How To Use Server Profiler In SQL

Yasin Panwala

Yasin Panwala is a Web Developer and Author at TheCodeHubs. He has experience in Web Developing and Designing and also in Writing. He has got his skills in working on technologies like .NET Core, ADO.NET, AJAX, Angular, AngularJS, ASP.NET, ASP.NET MVC, Bootstrap, C#, CSS, Entity Framework, Express.js, GraphQL, HTML, JavaScript, JQuery, JSON, LINQ, Microsoft Office, MongoDB, MySQL, Node.js, PostgreSQL, SQL, SQL Server, TypeORM, TypeScript, Visual Basic .NET, Web API. He also got his skills in working with different integration and some known versioning tools. He is always ready to learn new things and he always tries his best on tasks that are assigned to him and gives the best possible outputs.