Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Returns the number of characters in a character expression.
LEN(cExpression)
Return Values
Numeric
Parameters
- cExpression
Specifies the character expression for which LEN( ) returns the number of characters.
Remarks
Use LEN( ) to determine the length of a character expression.
Example
The following example opens the customer table in the testdata database. LEN( ) is used to display the widths of the cust_id and contact fields.
CLOSE DATABASES
OPEN DATABASE (HOME(2) + 'Data\testdata')
USE Customer && Open customer table
CLEAR
? 'Width of contact field: '
?? LEN(contact)
? 'Width of cust_id field: '
?? LEN(cust_id)