Click above to get retro games delivered to your door ever month!

FIELDNUM()

Syntax:     FIELDNUM(<expC>)

Arguments:  <expC> denotes the name of a field.

Returns:    A numeric value.
            The number returned is the number of the field.

Usage:      FIELDNUM() is the reverse of the Clipper FIELD() function.
            This function can be employed when it is required to use a
            field number in a program instead of a field name.
            However, with FIELDNUM() it is also possible to establish
            whether the name of a variable pertains to a field or a
            memory variable.

Notes:      The function will return a 0 if no such field <expC> exists in
            this SELECT area.

Library:    CT1.LIB


--------------------------------- Example ------------------------------

Examples:   IF FIELDNUM(name) > 0
               REPLACE name WITH UPPER(name)
            ELSE
               name = UPPER(name)
            ENDIF