RTRIM
Removes all consecutive occurrences of common whitespace (ASCII character 32) from the end of a string. It doesn’t remove other kinds of whitespace characters (tab, no-break space, etc.).
Syntax
RTRIM(<target>)
Parameter | Description |
---|---|
<target> | The string to be trimmed. |
Example
SELECT
RTRIM('Hello, world! ');
Returns: Hello, world!