CHAR_LENGTH function [String]

Function

Returns the number of characters in a string.

Syntax

CHAR_LENGTH ( string-expression )

Parameters

string-expression The string whose length is to be calculated.

Usage

Trailing white space characters are included in the length returned.

The return value of a NULL string is NULL.

If the string is in a multibyte character set, the CHAR_LENGTH value may be less than the BYTE_LENGTH value.

Example

The following statement returns the value 8.

SELECT CHAR_LENGTH( 'Chemical' ) FROM iq_dummy

Standards and compatibility

SQL/92 This function is SQL/92 compatible.

Sybase Compatible with Adaptive Server Enterprise.

See also

“BYTE_LENGTH function [String]”