{ "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": "value NOT BETWEEN lower_bound AND higher_bound is the same as \"value < lower_bound OR value > higher_bound\".", "tags": ["bound", "contained", "exclude", "found", "range"] }