Max Length of Data in a column

Use the datalength function to find the length of a "text" column in SQL Server.

To find the max length of a value in your column combine with the Max function.

select MAX( datalength(last_name))
from LP_COMMON.fpm.xAD_LANDOWNERS