IsNotBetween

Table of Contents



Returns true (1) if the value is outside of the given range. The range boundaries are considered inside the range.

Boolean IsNotBetween(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 not between 2 and 13.
SELECT Id, Text FROM WordList:Word WHERE IsNotBetween(Id, 2, 13) = 1