SQL•SQL References

MS Access RTrim() Function

Example

SELECT
RTrim("SQL Tutorial    ") AS RightTrimmedString;

Definition and Usage

The RTrim() function removes trailing spaces from a string.

Note

Parameter	Description
string	Required. The string to remove trailing spaces from

Works in:	From Access 2000

Loading lesson path

SQL•SQL References

Example

SELECT
RTrim("SQL Tutorial    ") AS RightTrimmedString;

The RTrim() function removes trailing spaces from a string.

Note

Parameter	Description
string	Required. The string to remove trailing spaces from

Works in:	From Access 2000