Skip to main content

LEN() Function

Definition The LEN() function returns the number of characters of an input string.    Note: Trailing spaces at the end of the string is not included when calculating the length. However, leading spac

Updated over 2 weeks ago

Definition

The LEN() function returns the number of characters of an input string.

Note: Trailing spaces at the end of the string is not included when calculating the length. However, leading spaces at the start of the string is included when calculating the length.

Syntax

LEN(string)

where string is a required a parameter and is the string to return the length for. If string is NULL, it returns NULL.

Example(s)

What to use in Custom SQL field:

  • LEN([Employee: First Name])

  • LEN('Hello World')

Field Outputs:

mceclip1.png

Did this answer your question?