[<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
 MIN()
 Return the smaller of two numeric or date values
------------------------------------------------------------------------------
 Syntax

     MIN(<nExp1>, <nExp2>) --> nSmaller
     MIN(<dExp1>, <dExp2>) --> dSmaller

 Arguments

     <nExp1> and <nExp2> are the numeric values to be compared.

     <dExp1> and <dExp2> are the date values to be compared.

 Returns

     MIN() returns the smaller of the two arguments.  The value returned is
     the same data type as the arguments.

 Description

     MIN() is a numeric and date function that ensures the value of an
     expression is smaller than a specified minimum.  The inverse of MIN() is
     MAX() which returns the greater of two numeric or date values.

 Examples

     .  In these examples MIN() returns the smaller of two numeric
        values:

        ? MIN(99, 100)                  // Result: 99
        ? MIN(100, 99)                  // Result: 99

     .  In these examples MIN() compares date values:

        ? DATE()                        // Result: 09/01/90
        ? MIN(DATE(), DATE() + 30)      // Result: 09/01/90

 Files   Library is CLIPPER.LIB.


See Also: MAX()
This page created by ng2html v1.05, the Norton guide to HTML conversion utility. Written by Dave Pearson