Eine Einführung in
SQL
lower case
SQLite
UPPER CASE is similar.
SELECT LOWER(name) FROM cia WHERE UPPER(region)='SOUTH AMERICA'
Specific to SQLite
none
DB2
UPPER CASE is similar.
SELECT LOWER(name) FROM cia WHERE UPPER(region)='SOUTH AMERICA'
Specific to DB2
none
MS Access
UPPER CASE is similar.
SELECT LCase(name) FROM cia WHERE UCase(region)='SOUTH AMERICA'
Specific to MS Access
LCase and UCase. Note that when testing strings case is ignored.
PostgreSQL
UPPER CASE is similar.
SELECT LOWER(name) FROM cia WHERE UPPER(region)='SOUTH AMERICA'
Specific to PostgreSQL
none
Oracle
UPPER CASE is similar.
SELECT LOWER(name) FROM cia WHERE UPPER(region)='SOUTH AMERICA'
Specific to Oracle
none
MS SQL Server
UPPER CASE is similar.
SELECT LOWER(name) FROM cia WHERE UPPER(region)='SOUTH AMERICA'
Specific to MS SQL Server
none
MySQL
UPPER CASE is similar.
SELECT LOWER(name) FROM cia WHERE UPPER(region)='SOUTH AMERICA'
Specific to MySQL
none
Sybase
UPPER CASE is similar.
SELECT LOWER(name) FROM cia WHERE UPPER(region)='SOUTH AMERICA'
Specific to Sybase
none
Mimer SQL
UPPER CASE is similar.
SELECT LOWER(name) FROM cia WHERE UPPER(region)='SOUTH AMERICA'
Specific to Mimer SQL
none