LEN() Function in Sql Server

Introduction:

The LEN() function returns the length of the value in a text field.

Syntax:

SELECT LEN(column_name) FROM table_name;

Example:

SELECT CustomerName,LEN(Address) as LengthOfAddress
FROM Customers;