Lower case

From SQLZOO
Jump to navigation Jump to search

Lower case

schema:gisq

UPPER CASE is similar.

SELECT LOWER(name) FROM bbc
 WHERE UPPER(region)='SOUTH AMERICA'
SELECT LOWER(name) FROM bbc
 WHERE UPPER(region)='SOUTH AMERICA'
SELECT LOWER(name) FROM bbc
 WHERE UPPER(region)='SOUTH AMERICA'
SELECT LCase(name) FROM bbc
 WHERE UCase(region)='SOUTH AMERICA'
SELECT LOWER(name) FROM bbc
 WHERE UPPER(region)='SOUTH AMERICA'
SELECT LOWER(name) FROM bbc
 WHERE UPPER(region)='SOUTH AMERICA'
SELECT LOWER(name) FROM bbc
 WHERE UPPER(region)='SOUTH AMERICA'
SELECT LOWER(name) FROM bbc
 WHERE UPPER(region)='SOUTH AMERICA'
SELECT LOWER(name) FROM bbc
 WHERE UPPER(region)='SOUTH AMERICA'
SELECT LOWER(name) FROM bbc
 WHERE UPPER(region)='SOUTH AMERICA'