Export (0) Print
Expand All
Expand Minimize

SET FIXED Command

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.

SET FIXED is scoped to the current data session.

Community Additions

ADD
Show:
© 2014 Microsoft