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 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

Selects words whose Id is between 2 and 4 (inclusive).

SELECT Id, Text FROM WordList:Word WHERE IsBetween(Id, 2, 4) = 1

Evaluates constant values.

SELECT IsBetween(50, 10, 100) as InRange, IsBetween(200, 10, 100) as OutOfRange FROM Single

Returns null when the value equals compareToValue, otherwise returns the value.

Returns null when the number equals compareToValue, otherwise returns the number.

Returns x raised to the power of y.

Returns the given number of characters from the end of the value.

Rounds a number to the given number of decimal places. Midpoint values are rounded to the nearest even number (2.5 rounds to 2).

Scalar functions are evaluated once per row.

Returns the SHA-1 hash of the value's UTF-8 bytes as a lower case hex string.

Returns the SHA-256 hash of the value's UTF-8 bytes as a lower case hex string.

Returns the SHA-512 hash of the value's UTF-8 bytes as a lower case hex string.

Lists the built-in scalar functions with their parameters and descriptions.