------------------------------------------------------------------------
-- John David Ayers ----------------------------------------------------
-- September 17, 2009 --------------------------------------------------
-- SELECT COMMAND 2 ----------------------------------------------------
------------------------------------------------------------------------

USE SalesOrders
SELECT CustFirstName, CustLastName
FROM Customers;

--SELECT Together

SELECT CustFirstName + ' ' + CustLastName
FROM Customers;

SELECT CustFirstName + ' Lives in ' + CustCity + ', ' + CustState AS [Customer Name]
FROM Customers;
