combining first name and last name as name in sql server code example

Example: join first name and last name sql

SELECT CONCAT(first_name , ' ', last_name) as Name from TableName