SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

SQL/MX Functions and Expressions

HP NonStop SQL/MX Reference Manual—544517-008

9-127

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-38.

Considerations for RTRIM

Result of RTRIM

The result is always of type NON ANSI 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-158 and LTRIM Function on page 9-84.

RTRIM (character-expression)