Link Search Menu Expand Document

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!