COL_LENGTH

Returns the defined length, in bytes, of a column.

Syntax

COL_LENGTH ( 'table' , 'column' )

Arguments

' table '

Is the name of the table for which to determine column length information. table is an expression of type nvarchar.

' column '

Is the name of the column for which to determine length. column is an expression of type nvarchar.

Return types

smallint

Example

SELECT COL_LENGTH('BasicDataTable', 'FloatValue');

See Also