LEN()

Class

Expressions and Type Conversion

Purpose

Function to return length of specified expression

Syntax

LEN(<exp>[,<expL>])

See Also

AT(), LEFT(), RAT(), RIGHT(), STREXTRACT(), STRTRAN(), STUFF(), SUBSTR()

Description

The LEN() function returns the output width of the specified expression <exp>. The expression can be of any data type, including memo fields and arrays. When checking the length of character expressions, the optional <expL> can be specified. If <expL> is specified and evaluates to .T. (true), the LEN() function will return the length of the character expression after stripping any formatting options such as BOLD().

Example

? len(name)
        20
? len(notepad)
       213
? len("")
         0
? len(bold("Hello"))
         9
? len(bold("Hello"),.T.)
         5

Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer