kingberrill of SQL
6/1/2017 - 9:34 PM

UPPER() and LOWER()

UPPER() and LOWER()

upper_lower.sql
content_copyfile_download
SELECT UPPER(<value or column>) FROM <table>;

SELECT first_name || " " || UPPER(last_name) AS "full_name", library_id FROM patrons;

SELECT LOWER(title) AS "lowercase_title", UPPER(author) AS "uppercase_author" FROM books;


SELECT LOWER(<value or column>) FROM <table>;