how to combine first and last name in sql server code example

Example: how to combine first and last nae into one columb sql

select CONCAT(FirstName , ' ' , MiddleName , ' ' , Lastname) as Name from 
  TableName