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://darkslategrey-bat-805937.hostingersite.com)