LPAD

Use LPAD to pad the left of a string with values up to an overall string length. The first parameter are the padding characters; enclose the characters with single quotes. The second parameter is the string expression. The third parameter is the overall length.

Syntax

LPAD('padding_characters',string_expression, overall_length)