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
EXAMPLE
This example illustrates two ways to use the RPAD function:
NOTES
- The first argument to the function must be of type CHARACTER. The second argument to the function must be of type INTEGER. The third argument, if specified, must be of type CHARACTER. If the third argument is not specified, the default value is a string of length 1 containing one blank.
- If
L1
is the length of the first argument andL2
is the value of the second argument:- The result is of type CHARACTER.
- If the argument expression evaluates to null, the result is null.
char_expression
andpad_expression
may contain multi-byte characters.length
represents the number of characters in the result.COMPATIBILITY
Progress Extension
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |