MS Access RTrim() Function

Posted by

MS Access

RTrim()

Function

Example

Remove trailing spaces from a string:

SELECT
RTrim(“SQL Tutorial    “) AS RightTrimmedString;


Definition and Usage

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


Note:

See also the
LTrim()
function.

Syntax

RTrim(

string

)

Parameter Values

Parameter Description

string
Required. The string to remove trailing spaces from

Technical Details

Works in: From Access 2000