IsBetween

Table of Contents



Returns true (1) if the value is within the given range, including the range boundaries.

Boolean IsBetween(Numeric value, Numeric rangeLow, Numeric rangeHigh)

Boolean results

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


round-pushpin Selects words whose Id is between 2 and 4 (inclusive).
SELECT Id, Text FROM WordList:Word WHERE IsBetween(Id, 2, 4) = 1

round-pushpin Evaluates constant values.
SELECT IsBetween(50, 10, 100) as InRange, IsBetween(200, 10, 100) as OutOfRange FROM Single