Lower case

From SQLZOO
Revision as of 14:38, 17 July 2012 by Connor (Talk | contribs) (Created page with "Lower case <div class='ht'> <div class=params>schema:gisq</div> <div> UPPER CASE is similar. </div> <source lang=sql class='tidy'> </source> <source lang=sql class='setup'></...")

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, 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'