The REAL data type is used to store single-precision floating-point numbers stored in 4 bytes.

Syntax

REAL

Remarks

The REAL data type is an approximate numeric data type; it is subject to roundoff errors after arithmetic operations.

The range of values is -3.402823e+38 to 3.402823e+38, with numbers close to zero as small as 1.175494e-38. Values held as REAL are accurate to 7 significant digits, but may be subject to round-off error beyond the sixth digit.

The approximate nature of REAL values means that queries using equalities should generally be avoided when comparing REAL values

See also

• DOUBLE data type
• FLOAT data type
• DECIMAL data type
• NUMERIC data type
• Numeric functions
• Aggregate functions

Standards and compatibility