Specifies if the number of decimal places used in the display of numeric data is fixed.
Syntax
SET FIXED ON | OFF
Arguments
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
SET FIXED is scoped to the current data session.