Function: lpad

Syntax

lpad (<string>,<char> {,<num>} )

Type

string

Returns

A string value prefixed with a number of occurrences of a character.

Parameters

• <string>
  A string value to be edited.

• <char>
  A text character. <string> is padded out with occurrences of this until its length is <num>.

• <num>
  The final length of the result. If <string> already has a length greater or equal to this, no action is taken.

Examples

Pad out to the left with spaces a string to a new length of 10.

string newval = lpad(oldval,' ',10)

See Also