Progress
SQL-92
Guide and Reference


RTRIM Function

Removes all the trailing characters in char_expression that are present in char_set and returns the resultant string. The last character in the result is guaranteed not to be in char_set. If you do not specify a char_set, trailing blanks are removed.

SYNTAX

RTRIM ( char_expression [ , char_set ] ) 

EXAMPLE

This example illustrates the RTRIM function:

SELECT RPAD ( RTRIM (addr, ’ ’), 30, ’.’) 
     FROM customer ; 

NOTES

COMPATIBILITY

ODBC Compatible


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095