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 :: DateTimeUTC
Returns the current UTC date and time, formatted with the optional .NET date/time format string. See DateTime for the format specifiers.
SQL :: Expressions
Literals, operators, comments and variables in KBSQL.
SQL :: Floor
Returns the largest whole number that is less than or equal to the given number.
SQL :: FormatDateTime
Parses a date/time value and returns it formatted with a .NET date/time format string. See DateTime for the format specifiers.
SQL :: FormatNumeric
Formats a number using a .NET numeric format string and returns the result as text.
SQL :: Guid
Returns a new random globally unique identifier.
SQL :: IfNull
Returns the given value, or the default value when the given value is null.
SQL :: IfNullNumeric
Returns the given number, or the default number when the given value is null.
SQL :: IIF
Short for "immediate if": returns whenTrue when the condition is true and whenFalse otherwise. The condition is usually one of the boolean functions such as IsEqual or IsGreater.
SQL :: IndexOf
Returns the zero-based position of the first occurrence of textToFind in textToSearch, starting the search at offset. Returns -1 when it is not found.