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