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