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 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 not between 2 and 13.

SELECT Id, Text FROM WordList:Word WHERE IsNotBetween(Id, 2, 13) = 1

Returns true (1) if the two given values are not equal. The comparison is case-sensitive.

Returns true (1) if the text does not match the pattern. See Like for the wildcards.

Returns true (1) if the given value is null, otherwise false (0). This is how to test for missing fields and for the unmatched side of an outer join.

Returns true (1) if the given value is a number: digits with an optional leading sign and an optional decimal point. Null and empty values return 0.

Returns true (1) if the given value cannot be converted to a number.

Returns the zero-based position of the last occurrence of textToFind in textToSearch. Returns -1 when it is not found.

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

Returns the number of characters in the given value.

Returns null when the conditional is true, otherwise returns the value.

Returns null when the conditional is true, otherwise returns the number.