The following table describes the arguments for this command:

String. The string values with the specified characters in the

trim_set

argument removed.

NULL if a value passed to the function is NULL.

The following expression removes the characters ‘re’ from the strings in the LAST_NAME port:

RTRIM removes ‘e’ from Page even though ‘r’ is the first character in the

trim_set

. This is because RTRIM searches, character-by-character, for the set of characters you specify in the

trim_set

argument. If the last character in the string matches the first character in the

trim_set

, RTRIM removes it. If, however, the last character in the string does not match, RTRIM compares the second character in the

trim_set

. If the second from last character in the string matches the second character in the

trim_set

, RTRIM removes it, and so on. When the character in the string fails to match the

trim_set

, RTRIM returns the string and evaluates the next row.

In the last example, the last character in Nelson does not match any character in the

trim_set

argument, so RTRIM returns the string 'Nelson' and evaluates the next row.

Use RTRIM and LTRIM with || or CONCAT to remove leading and trailing blanks after you concatenate two strings.

You can also remove multiple sets of characters by nesting RTRIM. For example, if you want to remove trailing blanks and the character ‘t’ from the end of each string in a column of names, you might create an expression similar to the following: