SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Functions and Expressions
HP NonStop SQL/MX Reference Manual—523725-004
9-125
RTRIM Function
RTRIM Function
The RTRIM function removes trailing spaces from a character string.
RTRIM is an SQL/MX extension.
character-expression
is an SQL character value expression and specifies the string from which to trim
trailing spaces. See Character Value Expressions on page 6-39.
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.
Examples of RTRIM
•
Return ' Robert':
RTRIM (' Robert ')
See TRIM Function on page 9-160 and LTRIM Function on page 9-80.
RTRIM (character-expression)