CHAR_LENGTH

The function returns the number of symbols in the specified string expression.

Syntax

CHARACTER_LENGTH (string_expression)

CHAR_LENGTH (string_expression)

string_expression - can be a constant, attribute or result of the function that returns a string.

The following example searches for all users whose otherTelephone attribute is less then 6 digits.

SELECT $otherTelephone FROM ROOTDSE 
WHERE EXISTS $otherTelephone AND CHARACTER_LENGTH($otherTelephone)<6;