datalength

In contrast to col_length, which finds the defined length of a column, datalength reports the actual length, in bytes, of the data stored in each row. Use this function on varchar, nvarchar, univarchar, varbinary, text, unitext, and image datatypes, since they can store variable lengths and do not store trailing blanks. datalength of any NULL data returns NULL. When a char value is declared to allow NULLS, Adaptive Server stores it internally as a varchar. All other datatypes report their defined length. Here is an example that finds the length of the pub_name column in the publishers table:

select Length = datalength(pub_name), pub_name 
from publishers 
Length  pub_name
------  ------------------------ 
13      New Age Books
16      Binnet & Hardley
20      Algodata Infosystems
 
(3 rows affected)