Progress
SQL-92
Guide and Reference


RPAD Function

Pads the character string corresponding to the first argument on the right with the character string corresponding to the third argument. After the padding, the length of the result is equal to the value of the second argument length.

SYNTAX

RPAD ( char_expression, length [ , pad_expression ] ) 

EXAMPLE

This example illustrates two ways to use the RPAD function:

SELECT RPAD (last_name, 30) 
     FROM customer ;
 
SELECT RPAD (last_name, 30, ’.’) 
     FROM customer ; 

NOTES

COMPATIBILITY

Progress Extension


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