bugl
bugl
HomeLearnPatternsSearch
HomeLearnPatternsSearch

Loading lesson path

Learn/SQL/SQL References
SQL•SQL References

MS Access Len() Function

Concept visual

MS Access Len() Function

Pointer walk
two pointers
leftright102132436485116
left=0
right=6
1
3

Start at both ends

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(

Formula

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;

Previous

❮ MS Access Functions

Next

Previous

MS Access Left() Function

Next

MS Access LTrim() Function