Expand Minimize
0 out of 1 rated this helpful - Rate this topic

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.

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.