In the last chapter, you learned what a function was. You looked at a few examples of functions, such as LOWER, that performed a specific operation on a particular column’s value for every record. The LOWER function
was used to convert every record’s last_name value into a lowercase version of the last_name.
SELECT id,
last_name,
LOWER(last_name)
FROM employee;
The results of this query show the last_name records in lowercase.
ID | LAST_NAME | LOWER(LAST_NAME) |
|---|---|---|
1 | JONES | jones |
2 | SMITH | smith |
3 | KING | king |
4 | SIMPSON | simpson |
5 | ANDERSON | anderson |
6 | COOPER | cooper |
7 | ADAMS | adams |
8 | SMITH | smith |
9 | PATRICK |
