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.