MS Access Len() Function

Posted by

MS Access

Len()

Function

Example

Return the length of a string:

SELECT Len(“SQL Tutorial”) AS LengthOfString;


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;