Topic group Related topics Example
Returns the length of the field in a specified position of a table.
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.
The work area you want to check.
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.
Check the length property of the Field object.