RTRIM function

The RTRIM function removes blanks from the end of a character string expression.

Syntax

RTRIM ( characterExpression )

A characterExpression is a CHAR, VARCHAR, or LONG VARCHAR data type, any built-in type that is implicitly converted to a string.

RTRIM returns NULL if characterExpression evaluates to null.

Examples

-- returns ' asdf'
VALUES RTRIM(' asdf  ')
-- returns 'asdf'
VALUES RTRIM('asdf  ')