The LPAD and RPAD functions truncate strings or pads them with spaces (or specified characters), to make all returned values the same specified length.

The length of the result string can be tuned by altering the configuration parameter “LPAD and RPAD return length”. From Studio, select Administration > Configuration > Server > SQL Engine > Overrides > LPAD and RPAD return length.

When this override option is set to TRUE, the functions LPAD and RPAD will result in a VARCHAR(4000). When set to FALSE the result will be a VARCHAR(2147483647). Default value for this option is FALSE.