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




SQL :: SubString
Returns length characters of the value, starting at the zero-based startIndex.
SQL :: Syntax
Basic KBSQL syntax and some examples.
SQL :: ToLower
Returns the value converted to lower case.
SQL :: ToNumeric
Returns the value converted to a number.
SQL :: ToProper
Returns the value with the first letter of each word capitalized (title case).
SQL :: ToString
Returns the number as a string, so that + concatenates it instead of adding it.
SQL :: ToUpper
Returns the value converted to upper case.
SQL :: Trim
Removes white space from the start and end of the value. When characters is given, each of those characters is removed from the start and end instead.