SQL-J Language Reference
Page 64 of 121

CHAR_LENGTH, CHARACTER_LENGTH

CHAR_LENGTH (or its synonym, CHARACTER_LENGTH) is applied to either a character string expression or a bit string expression and returns the number of characters in the result.

Because all built-in data types are implicitly converted to strings, this function can act on all built-in data types.

Syntax

CHAR[ACTER]_LENGTH ( { CharacterExpression | BitExpression } )

CHAR_LENGTH Examples

-- returns 20
VALUES CHAR_LENGTH('supercalifragilistic')

-- returns 1
VALUES CHAR_LENGTH(X'FF')

-- returns 3
VALUES CHAR_LENGTH(130)