Concatenate Columns in SQLServer

Explains that how to Concatenate columns in SQLServer.

Sometime we need to retrieve the details from the SQL server by concatenating multiple columns from the SQL Server.

An operator in a string expression that concatenates two or more character or binary strings, columns, or a combination of strings and column names into one expression (a string operator).

I have a simple  select query

Select * from dbo.EmpPersonalDetails

It shows result as below:

 

 

 

Now I want to display the result by concatenating First Three columns by the given below script

Select FirstName +' '+ MiddleName+' '+LastName As [Employee Full Name] from dbo.EmpPersonalDetails

It Shows result as below: