Text length | TEXT_LENGTH

Syntax

TEXT_LENGTH( [value] )

Parameters

value
The TEXT whose length is being calculated. If it is not a TEXT value, it will be converted to one with the STRING operation.

Return Value

The number of characters in VALUE.

Description

Counts the items in a TEXT.

Examples

TEXT_LENGTH("abcd") # returns 4

TEXT_LENGTH("") # returns 0

TEXT_LENGTH(null) # returns 0

TEXT_LENGTH(1234) # returns 4