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




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.