ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

LENGTH function [String]

Function 

Returns the number of characters in the specified string.

Syntax 

LENGTH ( string-expression )

Parameters 

string-expression    The string.

Usage 

If the string contains multi-byte characters, and the proper collation is being used, LENGTH returns the number of characters, not the number of bytes. If string is of BINARY data type, the LENGTH function behaves as BYTE_LENGTH.

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

• Sybase    Not supported by Adaptive Server Enterprise.

See also 

BYTE_LENGTH function [String]

International Languages and Character Sets

Example 

The following statement returns the value 9.

SELECT LENGTH( 'chocolate' )