---

Search posts under SQL Server:

---

Merge two column in SQL Server

How to merge two column value as one in SQL Server?

To merge two columns value as one, we can concatenate it as one and use alias for that value. This is the simplest way to do it.

SELECT FirstName + ' ' + LastName as FullName FROM PersonalDetails

Here the combination of FirstName and LastName is separated by a blank space and given as FullName.