select [CustomerID]
      ,[FirstName]
      ,[LastName]
      ,concat([FirstName], ' ', [LastName])
from [ex].[dbo].[Customers]