SQLzoo.net

Formatting numbers to two decimal places.

SQLite
DB2
Access
Postgres
Oracle
SQL Server
MySQL
Mimer
Sybase

Access
This rounds up or down	SELECT title, score, FORMAT(score,'.00') FROM movie WHERE id <= 10
Specific to Access
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.