Difference between revisions of "INRANGE()"

Latest revision as of 08:10, 4 February 2013

Purpose

Function to determine whether a specified expression is between two other specified expressions

Syntax

INRANGE(<exp1>,<exp2>,<exp3>)

See Also

BETWEEN(), CHROVERLAP(), EMPTY(), EVALUATE(), EXPRCHECK(), INLIST(), ISALPHA(), ISBLANK(), ISDIGIT(), MAX(), MAXVALUES(), MIN(), MINVALUES(), TYPE(), VARTYPE()

Description

The INRANGE() function returns true (.T.) if the value of a specified expression lies in the range delimited by two other expressions all of the same data type. The INRANGE() function operates on Character, Date and Numeric expressions.

The <exp1> must be equal to or more than <exp2> and equal to or less than <exp3> for INRANGE() to return true (.T). If <exp1> is not within this range, INRANGE() returns false (.F.).

Example

? inrange(date(),date()-10,date()+10)
.T.
? inrange("A", "A", "Z")
.T.
? inrange(10,1,9)
.F.