LENGTH

{LENGTH | CHAR_LENGTH | CHARACTER_LENGTH} (string)

Parameters

• string - an argument.

Description

Returns the number of characters in a string. This method returns a long. For BLOB, CLOB, BYTES and JAVA_OBJECT, the precision is used.

Example

SELECT LENGTH(name) FROM Players;