RTRIM
Returns a VARCHAR value representing a string with trailing blanks removed from the right side (end).
Behavior Type
Syntax
RTRIM ( expression [ , characters ] )
Parameters
expression |
(CHAR or VARCHAR) is the string to trim |
characters |
(CHAR or VARCHAR) specifies the characters to remove from the right side of expression. The default is the space character. |
Examples
=> SELECT RTRIM('trimzzzyyyyyyxxxxxxxx', 'xyz'); RTRIM ------- trim (1 row)