Lower case

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'

LCase and UCase. Note that when testing strings case is ignored.

Functions

Concatenate strings

Extracting substrings

lower case

Finding Substring

Formatting numbers

Replace NULL

Conditional values

Time now

Format dates