Merge two column 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.

Views: 58470 | Post Order: 56