COL_LENGTH function [System]

Function

Returns the defined length of a column.

Syntax

COL_LENGTH ( table-name, column-name )

Parameters

table-name The table name.

column-name The column name.

Example

The following statement returns the column length 35.

SELECT COL_LENGTH ( 'CUSTOMER', 'ADDRESS' ) FROM iq_dummy

Standards and compatibility

SQL/92 Vendor extension.

Sybase Adaptive Server Enterprise function implemented for Sybase IQ.

See also

“DATALENGTH function [System]”