CDO$HELP.HLB  —  Expressions  numeric_literals
    You can use a literal as a value expression. A literal is either
    a character string or a numeric literal.

    Numeric literals can take the following forms:

    o  A decimal string consisting of digits and an optional decimal
       point. The maximum length, not counting the decimal point, is
       19 digits.

    o  A decimal number in scientific notation (E-format), consisting
       of a decimal string mantissa and a signed integer exponent,
       separated by the letter D (for double), E (for E-format) or Q
       (for H_floating).

    CDO allows you to use unary plus and minus signs in numeric
    literals. Numeric literals must start and end with a numeral and
    cannot include hexadecimal digits. Numeric literals in E notation
    cannot include embedded spaces.

    The following expressions are valid numeric literals:

       +123
       -3.49
       0.3338889909
       6.03 E+23

    If you use a numeric literal to assign a value to a field or a
    variable, the data types of the field or variable determine the
    maximum value you can assign.

    A period at the end of a data definition command line terminates
    the command; therefore, you cannot use a decimal point to
    terminate a number if you want to include more data definition
    clauses in the statement.

    If you want to include more data definition clauses, include a
    zero after the decimal point, or place the value expression in
    parentheses:

       COMPUTED BY X * 2.0
       COMPUTED BY (X * 2.)
Additional Information: explode extract
Examples
Close Help