ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

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 multi-byte character set, the CHAR_LENGTH value differs from the number of bytes returned by BYTE_LENGTH.

Standards and compatibility 

• SQL/92    This function is SQL/92 compatible.

• SQL/99    Core feature.

• Sybase    Compatible with Adaptive Server Enterprise.

See also 

BYTE_LENGTH function [String]

Example 

The following statement returns the value 8.

SELECT CHAR_LENGTH( 'Chemical' )