portableSql
Truncate Portable SQL Function
Syntax
Truncate as N (Number as N, DecimalPlaces as N)
Arguments
- NumberNumeric
A numeric field or value.
- DecimalPlacesNumeric
The number of decimal places. A value greater than or equal to zero.
Returns
- resultNumeric
Returns the number truncated to a specified number of decimal places.
Description
Returns number truncated to a specified number of decimal places.
Discussion
The Truncate function truncates a number to the specified number of decimal places. See also NativeRound and Round.
Truncate() function executed on the Northwind Access database
SELECT FIRST 1 Truncate(5.994,1) AS EXPR1 FROM Products = 5.9