how to combine first and last nae into one columb sql code example

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

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