Product Solutions Support
Try MemSQL

RTRIM

Removes trailing space characters from the given string.

RTRIM (str)

Arguments

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).

memsql> select rtrim('    ohai     ') as r, ltrim('    ohai     ') as l;
+----------+-----------+
| r        | l         |
+----------+-----------+
|     ohai | ohai      |
+----------+-----------+
Was this article useful?