RTRIM

Description

The RTRIM function is used to remove consecutive spaces or specified characters from the right side (trailing) of a string.

Syntax

RTRIM( <str> [, <trim_chars> ] )

Parameters

Parameter	Description
<str>	The string that needs to be trimmed.
<trim_chars>	Optional parameter. If this parameter is provided, the RTRIM function will remove all characters in <trim_chars> that appear on the right side of <str>. If this parameter is not provided, the RTRIM function will only remove the space characters on the right side of <str>.

Return Value

Returns a string with trailing spaces or <trim_chars> removed. Special cases:

• If any Parameter is NULL, NULL will be returned.

Examples

SELECT rtrim('ab d   ') str;

+------+
| str  |
+------+
| ab d |
+------+

SELECT rtrim('ababccaab','ab') str;

+---------+
| str     |
+---------+
| ababcca |
+---------+