Length
Returns the number of characters in a field, including all spaces, numbers, and special characters.
Format
Length ( text )
Parameters
text - any text, number, date, time, timestamp, or container field, or any text expression or numeric expression
Data type returned
number
Originated in version
6.0 or earlier
Description
For a container field, Length returns the size of the original file in bytes.
Example 1
Length ( "John" ) returns 4.
Example 2
Length ( Description ) returns 12 when the value in Description is Modem for PC.
Example 3
Length ("M1" & Left ( Product ; 5 ) ) returns 7, when the Product field contains Canvas Backpack.