SQL•SQL References

MS Access Len() Function

Example

SELECT Len("SQL Tutorial") AS LengthOfString;

Definition and Usage

The Len() function returns the length of a string.

Syntax

Len(
string/varname
)

Parameter	Description
string/varname	Required. The string or variable name to return the length for

Works in:	From Access 2000

Loading lesson path

SQL•SQL References

Example

SELECT Len("SQL Tutorial") AS LengthOfString;

The Len() function returns the length of a string.

Syntax

Len(
string/varname
)

Parameter	Description
string/varname	Required. The string or variable name to return the length for

Works in:	From Access 2000