SQL
zoo.net
Conditional values
SQLite
DB2
Access
Postgres
Oracle
SQL Server
MySQL
Mimer
Sybase
Access
The SQL Standard is the
CASE statement
SELECT title, score, IIF(score>8.5,'Excellent','OK') FROM movie WHERE 10>id
Specific to Access
none
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.