COL_LENGTH Function [System]

Returns the defined length of a column.

Syntax

COL_LENGTH ( table-name, column-name )

Parameter

Description

table-name

The table name.

column-name

The column name.

Example

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 SAP Sybase IQ.

Parent topic: Alphabetical List of Functions
Related reference
BIT_LENGTH Function [String]
BYTE_LENGTH Function [String]
CHAR_LENGTH Function [String]
DATALENGTH Function [System]
LEN Function [String]
LENGTH Function [String]
OBJECT_NAME Function [System]
OCTET_LENGTH Function [String]
STR_REPLACE Function [String]