LEN()

Number of characters in textual value

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()