RTRIM

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

Syntax

RTRIM(CharacterExpression)

CharacterExpression

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

Results

A character string expression. If the CharacterExpression evaluates to NULL, this function returns NULL.

Examples

splice> VALUES RTRIM('     Space Case      ');
1
-------------
     Space Case	--- This is the string '   Space Case'

See Also