lpad

Returns "string_exp1" padded to length "integer_exp" with occurrences of "string_exp2". If "string_exp1" is longer than "integer_exp", the appropriate portion of "string_exp1" is returned.

Syntax

lpad ( string_exp1, integer_exp [ , string_exp2 ] )