SQL
zoo.net
lower case
SQLite
DB2
Access
Postgres
Oracle
SQL Server
MySQL
Mimer
Sybase
Access
UPPER CASE is similar.
SELECT LCase(name) FROM cia WHERE UCase(region)='SOUTH AMERICA'
Specific to Access
LCase and UCase. Note that when testing strings case is ignored.
Related links:
FUNCTIONS
Concatenate strings.
Substring: Extracting part of a string.
lower case
Finding a substring in a string
Formatting numbers to two decimal places.
Replace a NULL with a specific value
Conditional values
Get the date and time right now.
Format dates.