-
-
Notifications
You must be signed in to change notification settings - Fork 2.9k
/
NOT BETWEEN
31 lines (31 loc) · 1.02 KB
/
NOT BETWEEN
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
{
"name": "NOT BETWEEN",
"type": "operator",
"groups": ["Operators"],
"description": "Returns TRUE if value is not within the specified range. The range is considered inclusive of the bounds.",
"arguments": [{
"arg": "value",
"description": "the value to compare with a range. It can be a string, a number or a date."
}, {
"arg": "lower_bound AND higher_bound",
"description": "range bounds"
}],
"examples": [{
"expression": "'B' NOT BETWEEN 'A' AND 'C'",
"returns": "FALSE"
}, {
"expression": "1.0 NOT BETWEEN 1.1 AND 1.2",
"returns": "TRUE"
}, {
"expression": "2 NOT BETWEEN 2 AND 3",
"returns": "FALSE"
}, {
"expression": "'B' NOT BETWEEN 'a' AND 'c'",
"returns": "TRUE"
}, {
"expression": "lower('B') NOT BETWEEN 'a' AND 'b'",
"returns": "FALSE"
}],
"notes": "<i>value NOT BETWEEN lower_bound AND higher_bound</i> is the same as \"<i>value < lower_bound OR value > higher_bound</i>\".",
"tags": ["bound", "contained", "exclude", "found", "range"]
}