ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

DATALENGTH function [System]

Function 

Returns the length in bytes of the underlying storage for the result of an expression.

Syntax 

DATALENGTH ( expression )

Parameters 

expression    The expression is usually a column name. If the expression is a string constant, it must be enclosed in quotes.

Usage 

The return values of DATALENGTH are as follows:

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

• Sybase    Compatible with Adaptive Server Enterprise.

Example 

The following statement returns the value 27, the longest string in the company_name column.

SELECT following MAX( DATALENGTH( company_name ) )
FROM customer