Length

The Length function receives a single text string as input and returns an integer value representing the length of that string. If the input string is empty, the function will return '0'. This ensures consistent behavior and provides a convenient way to determine the length of text while handling empty strings gracefully. If the input is not a string type, or if any issues arise during the length calculation, the function returns NULL, ensuring reliability and predictability in its output.

Syntax

Length(string text)

Example

Length("Voca") -> returns '4'

Length("New York") -> returns '8'