LEN( )
Counts the number of characters in a string.
Syntax
LEN(str)
Argument
str
The string expression to evaluate.
Returns
The number of characters in the specified string.
Example
The following example returns the length of each value in the ProductCode data field:
LEN([ProductCode])
The following example uses LEN( ) in conjunction with the RIGHT( ) and FIND( ) functions to display the characters that appear after the hyphen in a product code. RIGHT( ) extracts a substring of a specified length, starting from the last character. In this example, the length of the entire string returned by LEN( ) minus the length up to the hyphen is the number of characters to display.
RIGHT( [PRODUCTNAME], LEN([PRODUCTNAME] ) - (FIND("-" ,[PRODUCTNAME] )))
If the product code is ModelA-Ford, RIGHT( ) returns the following string:
A-Ford