Share via


MIN( ) Function

Evaluates a set of expressions and returns the expression with the minimum value.

MIN(eExpression1, eExpression2 [, eExpression3 ...])

Return Value

Character, Numeric, Currency, Double, Float, Date, or DateTime

Parameters

  • eExpression1, eExpression2[, eExpression3...]
    Specify the set of expressions from which you want MIN( ) to return the expression with the lowest value. All the expressions must be of the same type.

Example

The following example uses APPEND BLANK to create a table with 10 records containing random values, then uses MIN( ) and MAX( ) to display the maximum and minimum values in the table.

CLOSE DATABASES
CREATE TABLE Random (cValue N(3))
FOR nItem = 1 TO 10  && Append 10 records,
   APPEND BLANK
   REPLACE cValue WITH 1 + 100 * RAND( )  && Insert random values
ENDFOR

CLEAR
LIST  && Display the values
gnMaximum = 1  && Initialize minimum value
gnMinimum = 100  && Initialize maximum value
SCAN 
   gnMinimum = MIN(gnMinimum, cValue)
   gnMaximum = MAX(gnMaximum, cValue)
ENDSCAN
? 'The minimum value is: ', gnMinimum  && Display minimum value
? 'The maximum value is: ', gnMaximum  && Display maximum value

See Also

Reference

CALCULATE Command

MAX( ) Function

Other Resources

Functions