ASA SQL Reference
SQL Functions
Alphabetical list of functions
Truncates a number at a specified number of places after the decimal point.
TRUNCNUM ( numeric-expression, integer-expression )
numeric-expression The number to be truncated.
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.
This function is the same as TRUNCATE, but does not cause keyword conflicts.
SQL/92 Vendor extension.
SQL/99 Vendor extension.
Sybase Not supported in Adaptive Server Enterprise.
The following statement returns the value 600.
SELECT TRUNCNUM( 655, -2 )
The following statement: returns the value 655.340.
SELECT TRUNCNUM( 655.348, 2 )