between

Returns whether or not a given value is within a range of values.

Example

Determine whether AMOUNT_SOLD is between 1000 and 2000.

between(Sales_Acme.Sales.AMOUNT_SOLD, 1000, 2000)

Syntax

between(double expr value, double expr min, double expr max)

• value : value to test
• min : lower limit of test range
• max : upper limit of test range

Returns

bool

Notes

Function between determines whether the value resulting from evaluating value fits within the range defined by evaluating the min and max expressions. The range is inclusive of the boundary values.