Neoview SQL Reference Manual (R2.4 SP2)

RTRIM Function
The RTRIM function removes trailing spaces from a character string. If you need to remove any
leading character other than space, use the TRIM function and specify the value of the character.
See the “TRIM Function” (page 468).
RTRIM is a Neoview SQL extension.
RTRIM (character-expression)
character-expression
is an SQL character value expression and specifies the string from which to trim trailing
spaces. See “Character Value Expressions” (page 243).
Considerations for RTRIM
Result of RTRIM
The result is always of type VARCHAR, with maximum length equal to the fixed length or
maximum variable length of character-expression.
Example of RTRIM
Return ' Robert':
RTRIM (' Robert ')
See “TRIM Function” (page 468) and “LTRIM Function” (page 406).
RTRIM Function 443