May 2005
Intermediate to advanced
352 pages
14h 39m
English
UCASE( )
UCASE(string)This
function converts the given string of text or a string from a column
to all uppercase letters. It is synonymous with UPPER() function.
SELECT course_id AS 'Course ID',
UCASE(course_name) AS Course
FROM courses LIMIT 3;
+-----------+----------------------+
| Course ID | Course |
+-----------+----------------------+
| 1245 | CREATIVE WRITING |
| 1255 | PROFESSIONAL WRITING |
| 1244 | AMERICAN LITERATURE |
+-----------+----------------------+Read now
Unlock full access