PAD_LEFT
Description
Pads the given string on the left with the specified character
Syntax
PAD_LEFT (text, character, length)
Cannot be used in the condition of a FIND action.
Parameters
Attribute of the Plain Text type or string constant or calculation producing text identifying the string to pad; the character to pad with; the resulting length of the string
Returns
Text: the string padded on the left with the character up to the given length.
Example
PAD_LEFT ('John', '0', 6)
returns 00John