Examples

LEN("Hello") : 5

LEN([Home Phone]) : The length of the Home Phone column value.

LEN("") : 0

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

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

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

Syntax

LEN( some-text )

Arguments

  • some-text (any textual type)

Return Value

Number: The count of characters in some-text.

See Also

COUNT(), LEFT(), MID(), RIGHT()

Did this answer your question?