Export (0) Print
Expand All

SET DECIMALS Command

Specifies the number of decimal places displayed in numeric expressions.


SET DECIMALS TO [nDecimalPlaces]

nDecimalPlaces

Specifies the minimum number of decimal places to display. The default is two decimal places. The maximum number of decimal places is 18; the minimum is zero.

SET DECIMALS specifies the minimum number of decimal places used to display the results of division, multiplication, and trigonometric and financial functions.

SET DECIMALS is scoped to the current data session.

Community Additions

Show:
© 2014 Microsoft