Specifies if the number of decimal places used in the display of numeric data is fixed.

SET FIXED ON | OFF

Parameters

ON

Uses the SET DECIMALS setting to determine the number of decimal places displayed in results. The default number of decimal places is 2.

OFF

(Default) Allows the number of decimal places displayed in results to depend on the specific constants, variables, and operators used in a numeric expression. The contents of fields are displayed with the declared number of decimal places.

Remarks

See Also