ASA SQL Reference
  SQL Data Types
    Numeric data types

REAL data type [Numeric]

Function 

A single-precision floating-point number stored in 4 bytes.

Syntax 

REAL

Usage 

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

The range of values is 1.175495e-38 to 3.402823e+38. Values held as REAL are accurate to 10 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

Standards and compatibility 

• SQL/92    Compatible with SQL/92.

• Sybase    Compatible with Adaptive Server Enterprise.