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

Was this helpful?

How can we improve it?

Need more help?

Try these next steps:

true
Search
Clear search
Close search
Google apps
Main menu
15633209376245772697
true
Search Help Center
true
true
true
false
false