SQL Functions   «Prev 

SQL Function - Exercise

Combining Functions

Objective: Write a query that combines several special SQL functions discussed in this module.
Given the following table:

MyTable

MyLastName MyFirstName MyAddress MyState
Create a SQL statement that will return the MyLastname column all uppercase, the MyFirstname column all lowercase, and the length of the MyAddress column. (Assume that your engine supports this option, and that it uses the LEN version of the function.)
Make sure you provide names for your columns.