SingleStore Managed Service

RTRIM

Removes trailing space characters from the given string.

Syntax
RTRIM (str)
Arguments
  • str: any string or binary object

Return Type

String

Examples

Notice

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      |
+----------+-----------+