SQL•SQL References

MS Access Trim() Function

Example

SELECT Trim("    SQL Tutorial    ") AS TrimmedString;

Definition and Usage

The Trim() function removes both leading and trailing spaces from a string.

Syntax

Trim(
string
)

Parameter	Description
string	Required. The string to strip both leading and trailing spaces from

Works in:	From Access 2000

Loading lesson path

SQL•SQL References

Example

SELECT Trim("    SQL Tutorial    ") AS TrimmedString;

The Trim() function removes both leading and trailing spaces from a string.

Syntax

Trim(
string
)

Parameter	Description
string	Required. The string to strip both leading and trailing spaces from

Works in:	From Access 2000