The DATALENGTH SQL returns the length of columns in a table.
SELECT length = DATALENGTH(ColumnName) FROM TableName ORDER BY ColumnName
Visit the DevX Tip Bank