LEN()

Returns the number of characters in textual value.

Sample usage

LEN("Hello")  returns  5

LEN(Home Phone) returns the length of the Home Phone column value.

LEN("") : 0

LEN(Some Column & "") = 0  returns  TRUE if Some Column has no value. Equivalent to ISBLANK(Some Column) . See also: ISBLANK()

LEN(Some Column & "") > 0  returns TRUE if Some Column has a value. Equivalent to ISNOTBLANK(Some Column) . See also: ISNOTBLANK()

LEN(Serial Number) = 10  returns TRUE if Serial Number is exactly 10 characters long. Suitable for use in a Valid_If column constraint or a format rule.

Syntax

LEN( text )

• text  - Any textual type.

See Also

COUNT()

LEFT()

MID()

RIGHT()