Summer Lewis

Use single-row functions in query

Task 3

select upper(ItemDescription) from Products;
select CustomerID, substring(CustomerID, 1, 5) from Customers;
select lower(CustomerID), upper(substring(FirstName, 1,2)), upper(substring(LastName, 1,3)) from Customers;