Function: RTrim

Description

Removes all spaces from the end of a string.

Syntax

RTrim(string)

Arguments

string can be a constant, a character field, an expression that results in a string or a function that returns a string.

Return value

This function returns a character string.

Calculated field example

If the Firstname field contained the value "Santa   ", the following calculated field expression would return "Santa": RTrim(Firstname)

Filter/Find example

Records with a Firstname field value of "Tom" or "Tom   " can be selected or found using the expression: RTrim(Firstname)="Tom"