LENGTH
Description
LENGTH
is a row function that returns the count of characters in a TEXT
value.Syntax
LENGTH
(string_expression
)Return Value
Returns one value per row of type
INTEGER
.Input Parameters
- string_expression
- Required. The name of a field or expression of typeTEXT(or a literal string).
Examples
Return count of characters from values in the
name
field. For example, the value Bob
would return a length of 3
, Julie
would return a length of 5
, and so on:LENGTH([name])