Progress
Report Builder
User’s Guide


IN-RANGE

Determines whether a value is within a specified range of values. Returns logical TRUE if the value is equal to or greater than the lowest value and equal to or less than the highest value. Returns FALSE if not.

SYNTAX

IN-RANGE ( value , low-value , high-value ) 

value

A value (a constant, field name, or expression) that you want to compare to a range of values.

low-value

The minimum value (a constant, field name, or expression) for the range against which you want Report Builder to compare the value.

high-value

The maximum value (a constant, field name, or expression) for the range against which you want Report Builder to compare the value.

NOTE

The value, low-value, and high-value must be the same data type: CHARACTER, NUMERIC, DATE, or LOGICAL expressions.

EXAMPLE

To determine whether the price of each item in the Item table is within the range of 4.95 and 6.95, create a calculated field containing this expression:

IN-RANGE(Price,4.95,6.95) 

Sample data:

Item-num Price    IN-RANGE(Price...)
903      12.95        NO
901       6.95        YES
902       5.00        YES
904       4.95        YES 


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095