Contents Index TRUNCATE function [Numeric] UCASE function [String]

ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

TRUNCNUM function [Numeric]


Function 

Truncates a number at a specified number of places after the decimal point.

Syntax 

TRUNCNUM ( numeric-expressioninteger-expression )

Parameters 

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.

Usage 

This function is the same as TRUNCATE, but does not cause keyword conflicts.

Standards and compatibility 
See also 

ROUND function [Numeric]

TRUNCATE function [Numeric]

Example 

The following statement returns the value 600.

SELECT TRUNCNUM( 655, -2 )

The following statement: returns the value 655.340.

SELECT TRUNCNUM( 655.348, 2 )

Contents Index TRUNCATE function [Numeric] UCASE function [String]