How to: |
Reference: |
RPAD uses a specified character and output length to return a character string padded on the right with that character.
RPAD(string, out_length, pad_character)
where:
Alphanumeric
Is a string to pad on the right side.
Integer
Is the length of the output string after padding.
Alphanumeric
Is a single character to use for padding.
RPAD right-pads the PRODUCT_CATEGORY column with @ symbols:
RPAD(PRODUCT_CATEGORY,25,'@')
For Stereo Systems, the output is Stereo Systems@@@@@@@@@@@.
WebFOCUS | |
Feedback |