In This Topic

Returns the integer (whole) part of a real number.

### Remarks

**This does not do any type of rounding**. It will only return the whole part of a real number. If you need to round the number use the ROUND function, or look at the CEILING / FLOOR functions.

This is not the same thing as a cast in C#/VB.Net. This is the math function to get the whole part of a number without rounding.

### Example

SELECT INT(3.1415);
SELECT INT(3.9999);
RETURNS: 3

See Also