IsIntegral

The IsIntegral function validates if the input parameter is a whole number.

Syntax

IsIntegral(<expression or value>)

Return Type

Boolean

Details

n/a

Examples

eval IsIntegral(100.1);

isintegral_false

eval IsIntegral(42);

isintegral_true

select
if IsIntegral(amount) = true then 'whole number' else 'not a whole number' end,
count(*)
from staging.order_item;

isintegral_case

Related Functions

IsDateTimeFormat

IsNumberFormat

TypeNameOf