ASA SQL Reference
SQL Functions
Alphabetical list of functions
Returns the number of characters in the specified string.
LENGTH ( string-expression )
string-expression The string.
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.
SQL/92 Vendor extension.
SQL/99 Vendor extension.
Sybase Not supported by Adaptive Server Enterprise.
International Languages and Character Sets
The following statement returns the value 9.
SELECT LENGTH( 'chocolate' )