CHAR_LENGTH

Returns the character length of the input string.

Syntax

CHAR_LENGTH(expression STRING) → INTEGER

• expression: The expression (VARCHAR) to determine character length for.

Examples

CHAR_LENGTH example

SELECT CHAR_LENGTH('get the char length')
-- 19

CHAR_LENGTH example

SELECT CHAR_LENGTH('SPICE')
-- 5