Combines a table's FirstName and LastName attributs to form a single aliased Attribute while handling NULL in various ways.

CombiningFirstNameAndLastName.sql

SELECT empid, firstname + N' ' + lastname AS full_name
FROM HR.Employees

SELECT 
  empid,
	--country + N', ' + region + N', ' + city AS location
	--country + COALESCE(N',' + region, N'') + N',' + city AS location
	CONCAT(country + N', ',  region + N', ', + city ) AS location
FROM HR.Employees