LPAD

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

Prepends padding to a string on the left to a specified length.

1lpad(<string>, <length> [, fill])

• <string>: The string to pad.
• <length>: The desired total length.

• fill: The padding characters. Defaults to space.

Returns a text value padded to the specified length.

• If the string is longer than the specified length, it is truncated on the right.
• The fill string is repeated as needed.

Pad a string on the left.

1SELECT lpad('hi', 5, 'xy') AS result;

Returns 'xyxhi'.

• String Types