MS Access Len() Function
Example
Return the length of the string:
SELECT Len("SQL Tutorial") AS LengthOfString;
Try it Yourself »
Definition and Usage
The Len() function returns the length of the specified string.
Syntax
Len(string)
Parameter Values
| Parameter | Description |
|---|---|
| string | Required. The string to return the length for |
Technical Details
| Works in: | Access 2016, Access 2013, Access 2010, Access 2007, Access 2003, Access XP, Access 2000 |
|---|
More Examples
Example
Return the length of the text in the "CustomerName" column:
SELECT Len(CustomerName) AS LengthOfString
FROM Customers;
Try it Yourself »
