LPAD

Pads string on the left with fill character to reach specified width.

Category: String Functions

Syntax

LPAD(string, width, fill)

Arguments

• string varchar String input value.
• width integer [constant] Target width for the output. Must be a constant expression.
• fill varchar [constant] Padding text used when the input is shorter than the target width. Must be a constant expression.

Returns

VARCHAR — Returns the computed result as VARCHAR.