Char Length

String Function

Description

Returns the number of characters in string.

Click here to navigate to the PostgreSQL docs page for this syntax.

The function Char_length() is translated to LENGTH()in Snowflake.

Grammar Syntax

CHAR_LENGTH(string)

Sample Source Patterns

PostgreSQL

Code

SELECT CHAR_LENGTH('#000000123');

Result

10

Snowflake

Code

SELECT LENGTH('#000000123');

Result

10