LEN

Returns the number of characters in the specified string.

LEN ( <field_name or string> )

  • field name or string: The field or string to obtain the length of.

Example: create a field on the CUSTOMER table that returns the length of their surname.

LEN([CUSTOMER.SURNAME])