Sams Teach Yourself SQL in 24 Hours (5th Edition) (Sams Teach Yourself -- Hours)

Used to select a portion of a character string

SUBSTR

Used to trim characters from either the right or left of a string

LTRIM/RTRIM

Used to change all letters to lowercase

LOWER

Used to find the length of a string

LENGTH

Used to combine strings

CONCATENATION (CONCATENATION is the same as .)

True or false: Using functions in a select statement to restructure the appearance of data in output will also affect the way the data is stored in the database.

True.

True or false: The outermost function is always resolved first when functions are embedded within other functions in a query.

False. The innermost function is always resolved first when embedding functions within one another.

Type the following code at the mysql> prompt to concatenate each employee's last name and first name :

SELECT CONCAT(LAST_NAME, ', ', FIRST_NAME) FROM EMPLOYEE_TBL;

Type the following code to print each employee's concatenated name and their area code:

SELECT CONCAT(LAST_NAME, ', ', FIRST_NAME), SUBSTRING(PHONE, 1, 3) FROM EMPLOYEE_TBL;

Write a SQL statement that lists employee emails. Email is not a stored column. The email for each employee should be as follows :

FIRST.LAST@PERPTECH.COM

For example, John Smith's would be JOHN.SMITH@PERPTECH.COM.

Write a SQL statement that lists employee emails. Email is not a stored column. The email for each employee should be as follows:

FIRSTINITIAL.LAST@PERPTECH.COM

For example, John Smith's would be JSMITH@PERPTECH.COM.

SELECT CONCAT(SUBSTRING(FIRST_NAME,1,1), LAST_NAME, '@PERPTECH.COM') FROM EMPLOYEE_TBL;

Write a SQL statement that lists each employee's name, employee ID, and phone number in the following formats:

NAME = SMITH, JOHN EMP_ID = 999-99-9999 PHONE = (999)999-9999

NAME = SMITH, JOHN PHONE = (999)999-9999 SELECT CONCAT(LAST_NAME, ', ', FIRST_NAME), CONCAT('(',SUBSTRING(PHONE,1,3),')',SUBSTRING(PHONE,4,3),'-', SUBSTRING(PHONE,7,4) FROM EMPLOYEE_TBL;