SQLzoo.net

lower case

SQLite
DB2
Ingres
Access
Postgres
Oracle
SQL Server
MySQL
Mimer
Sybase

SQL Server
UPPER CASE is similar.	SELECT LOWER(name) FROM cia WHERE UPPER(region)='SOUTH AMERICA'
Specific to SQL Server
none

Related links:

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.