Lower case
From SQLZoo
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'