THE WORLD'S LARGEST WEB DEVELOPER SITE

MS Access Len() Function

❮ MS Access Functions

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 »

❮ MS Access Functions