To measure the length of VARCHAR fields the function LEN(varcharfield) is useful. To measure the length of TEXT fields the function is DATALENGTH(textfield). Len will not work for text field. Example: SELECT DATALENGTH(yourtextfield) AS TEXTFieldSize Reference : Pinal Dave (https://blog.sqlauthority.com)