LPAD

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

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

  • <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.

Returns 'xyxhi'.