LEN()

Purpose

Function to return length of specified expression

Syntax

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

See Also

AT(), LEFT(), LENC(), RAT(), RIGHT(), SET STRESCAPE, STR_COMPRESS(), STR_UNCOMPRESS(), STREXTRACT(), STRLEN(), 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. The optional <expL> is ignored.

Use the LENC() function when working with Unicode/UTF-8 characters.

Example

open database southwind
use example
? len(last_name)
        16
? len(notes)
      8851
? len("")
         0