lpad

Description Syntax Parameters Returns Example
Pads a string on the left. lpad(strToPad, paddedStrLen, charToPad) strToPad: string or array of strings.

paddedStrLen: final length of padded string.

charToPad: character to pad with (Optional, Default is SPACE).

String. lpad('ABC’, 4)

lpad({'ABC', 'DEF'}, 4)