Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
SET DECIMALS Command
Collapse the table of content
Expand the table of content

SET DECIMALS Command

Specifies the number of decimal places displayed in numeric expressions.


SET DECIMALS TO [nDecimalPlaces]

Parameters

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

ADD
Show:
© 2015 Microsoft