ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

ROUND function [Numeric]

Function 

Rounds the numeric-expression to the specified integer-expression amount of places after the decimal point.

Syntax 

ROUND ( numeric-expression, integer-expression )

Parameters 

numeric-expression    The number, passed into the function, to be rounded..

integer-expression    A positive integer specifies the number of significant digits to the right of the decimal point at which to round. A negative expression specifies the number of significant digits to the left of the decimal point at which to round.

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

• Sybase    Compatible with Adaptive Server Enterprise.

See also 

TRUNCNUM function [Numeric]

Example 

The following statement returns the value 123.200.

SELECT ROUND( 123.234, 1 )