RTRIM

Returns a character expression after it removes trailing blanks.

Syntax

RTRIM ( string_expression ) 

Arguments

string_expression
A valid string expression.

Return Type

Returns values of type STRING.

Examples

Examples in this section use the example blockchain.

The following example returns the input after removing trailing blanks.

SELECT RTRIM(str + "    ") FROM example;

Response:

RTRIM(str + "    " ) [STRING]
NULL
d
lect
dialect