lpad

Returns "string_expression1" left-padded to the length defined by "integer_expression" with occurrences of "string_expression2". If "string_expression1" is longer than "integer_expression", the appropriate portion of "string_expression1" is returned.

lpad ( string_expression1, integer_expression [ ,
 string_expression2 ] )