1. Example. AS.sql

SELECT cus.FirstName,
        cus.LastName
FROM Customer cus;
GO

/** Output **/
FirstName                                LastName
---------------------------------------- ----------------------------------------
Paolo                                    Accorti
Pedro                                    Afonso
Maria                                    Anders
Miguel                                   Angel Paolino
Victoria                                 Ashworth
Bernardo                                 Batista
Helen                                    Bennett
Christina                                Berglund
...

SELECT (cus.FirstName + ' ' + cus.LastName) AS FullName --"Full Name"
FROM Customer cus;
GO

/** Output **/
FullName
---------------------------------------------------------------------------------
Paolo Accorti
Pedro Afonso
Maria Anders
Miguel Angel Paolino
Victoria Ashworth
Bernardo Batista
Helen Bennett
Christina Berglund
...