Outdated Version

You are viewing an older version of this section. View current production version.

RTRIM

Removes trailing space characters from the given string.

Syntax

RTRIM (str)

Arguments

  • str: any string or binary object

Return Type

String

Examples

Info

This function removes only space " " characters. Other whitespace characters like tab \t, newline \n, etc are preserved. It is equivalent to TRIM(TRAILING " " FROM str).

select rtrim('    ohai     ') as r, ltrim('    ohai     ') as l;
+----------+-----------+
| r        | l         |
+----------+-----------+
|     ohai | ohai      |
+----------+-----------+

Related Topics