To calculate the lenght of a TEXT field the LEN function used to calculate the length of VARCHAR fields won’t work.
You need to use the DATALENGTH T-SQL function:
SELECT DATALENGTH(myTextField) AS lengthOfMyTextField
POW·ER·CRAM NOUN, \ˈPAU̇(-Ə)R\ˈKRAM\ – CONSISE, USEFUL INFORMATION ABOUT COMPUTERS, NETWORKS AND CLOUD.
To calculate the lenght of a TEXT field the LEN function used to calculate the length of VARCHAR fields won’t work.
You need to use the DATALENGTH T-SQL function:
SELECT DATALENGTH(myTextField) AS lengthOfMyTextField