The LEN() Function
The LEN() function returns the length of the value in a text field.
SQL LEN() Syntax
SELECT LEN(column_name) FROM table_name;
Example
SELECT CustomerName,LEN(Address) as LengthOfAddress
FROM Customers;
FROM Customers;
The LEN() function returns the length of the value in a text field.