To measure the length of VARCHAR fields you can use the function
LEN(varcharfield) .
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
Markus