PAD_LEFT

Pads the given string on the left with the specified character

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

PAD_LEFT ('John', '0', 6) 

returns 00John

  • Last modified: 2023/05/09 01:15