SQL LEN() Function

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;

No comments yet.

Leave a Reply

*