Database Reference
In-Depth Information
Figure 9.6
Some String
Functions.
FLOOR(1.9) = 1
MOD(m, n)
. MOD is the modulus or remainder function, which
returns the remainder of the first value divided by the second value (
m
divided by
n
). The first value is returned if the second value is zero.
MOD(5,2) = 1
MOD(4,0) = 4
MOD(9,3) = 0
MOD(23,4) = 3
POWER(m, n)
. The exponential function raises
m
to the power of
n
(the
nth
power).
POWER(2,3) = 8 (2
3
= 2 * 2 * 2 = 4 * 2 = 8)
ROUND(n [, places])
. ROUND is a proper mathematical rounding
function as opposed to the CEIL and FLOOR functions. For the
ROUND function, a decimal 5 and over will be rounded up and
below 5 will be rounded down. The third example following is
rounded to two decimal places and the fourth to three decimal places.