THE WORLD'S LARGEST WEB DEVELOPER SITE

MS Access Len() Function

❮ MS Access Functions

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 »

❮ MS Access Functions