select [CustomerID]
      ,[FirstName]
      ,[LastName]
      ,[FirstName] + ' ' + [LastName] as FullName
from [ex].[dbo].[Customers]