Example
Return the integer part of a number:
sql
SELECT Int(756.43) AS IntNum;
Definition and Usage
The Int() function returns the integer part of a number.
Note: If number is negative, this function returns the first negative integer less than or equal to number.
Syntax
text
Int(number)
Parameter Values
| Parameter | Description |
|---|---|
| number | Required. A numeric value |
Technical Details
| Works in: | From Access 2000 |
|---|
More Examples
Example
Return the integer part of the "Price" column:
sql
SELECT Int(Price) AS IntNum FROM Products;