Database Tour Documentation
lpad function

Category:

Miscellaneous

Pads the left-side of a string with a specific set of characters.

Syntax

lpad(
  Str String,
  Count Numeric,
  Char String
): String

Parameters

Str is the string to pad characters to.

Count is the number of characters to return.

Char is the string that will be padded to the left-hand side of Str.

Return value

Type: String. Returns the resulted string.

Examples of using

lpad(dataset_field_val(1, 'PageNumber'), 4, '0')

lpad('17', 5, ' ')