SQLite UPPER and LOWER Functions

UPPER

 
select lastname, 
       UPPER(lastname)
from person;


lastname    UPPER(lastname)
---------   ---------------
Bag         BAG
Beam	    BEAM
Flintstone  FLINTSTONE

LOWER

 
select lastname, 
       LOWER(lastname)
from person;


lastname    LOWER(lastname)
---------   ---------------
Bag          bag
Meigh	     meigh
Sucks	     sucks

Schema and Data use on this page