Difference between revisions of "INRANGE()"
From Lianjapedia
Helen.george (Talk | contribs) |
|||
| (3 intermediate revisions by the same user not shown) | |||
| Line 11: | Line 11: | ||
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 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. | ||
| − | {| class="wikitable" | + | {| class="wikitable" width="100%" |
| − | !Parameters||Description | + | !width="30%"|Parameters||Description |
|- | |- | ||
|<exp1>||The expression to be checked. | |<exp1>||The expression to be checked. | ||
| Line 36: | Line 36: | ||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
| − | [[Category: | + | [[Category:Formatting Functions]] |
| − | + | ||
[[Category:Lianja VFP Extensions]] | [[Category:Lianja VFP Extensions]] | ||
[[Category:VFP Function Extensions]] | [[Category:VFP Function Extensions]] | ||
Latest revision as of 08:10, 4 February 2013
Contents
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.
| Parameters | Description |
|---|---|
| <exp1> | The expression to be checked. |
| <exp2> | Expression representing the range minimum. |
| <exp3> | Expression representing the range maximum. |
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.
