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