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 ( 'CUSTOMERS', 'ADDRESS' ) FROM iq_dummy

Standards and compatibility

SQL Vendor extension to ISO/ANSI SQL grammar.

Sybase Adaptive Server Enterprise function implemented for Sybase IQ

See also

“DATALENGTH function [System]”