Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
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:
© 2015 Microsoft