DESCEND()

    DESCEND() creates and SEEKS descending order indexes.

Syntax

    DESCEND(<exp>)

Argument

    <exp> is an expression of any data type.

Returns

    DESCEND() returns the same data type as the <exp> in a complemented
    form.

Usage

    DESCEND() is designed to be used in combination with INDEX and SEEK to
allow for the creation of descending order indexes.

    To use DESCEND() in an INDEX expression, use the following syntaxL:

INDEX ON DESCEND(Sales_date) TO date_dwn