CODE EXAMPLE FOR SQL

how to combine first and last nae into one columb sql

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