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.