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: