IsInteger

Table of Contents

Returns true (1) if the given value is a whole number, with an optional leading sign.

Boolean IsInteger(String value)

Boolean functions return 1 for true and 0 for false. In a WHERE clause compare the result to 1 (or true), for example: WHERE IsLike(Text, 'Cat%') = 1

Tests two values.

SELECT IsInteger('15') as WholeNumber, IsInteger('1.5') as Decimal FROM Single