MS Access Len() Function
Example
Return the length of a string:
SELECT Len("SQL Tutorial") AS LengthOfString;
Try it Yourself »
Definition and Usage
The Len() function returns the length of a string.
Syntax
Len(string/varname)
Parameter Values
Parameter | Description |
---|---|
string/varname | Required. The string or variable name to return the length for |
Technical Details
Works in: | From 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 »