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