FLENGTH( )

Topic group Related topics Example

Returns the length of the field in a specified position of a table.

Syntax

FLENGTH(<field number expN> [, <alias>])

<field number expN>

The position of the field whose length you want returned. The first field in a table is field number 1.

<alias>

The work area you want to check.

Description

FLENGTH( ) returns the length of a field in a table based on the specified <field number expN> parameter. The field length for numeric fields includes the decimal digits and one for the decimal point character. Certain field types have fixed lengths. For example, in a DBF table, FLENGTH( ) returns 8 for date fields and 10 for memo fields.

FLENGTH( ) returns 0 if the table does not contain a field in the specified position.

OODML

Check the length property of the Field object.