lpad

Returns "string_expression1" padded to length "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 
] )