LPAD Function | VantageCloud Lake - LPAD - Teradata Vantage

Returns the source_string padded to the left with the characters in fill_string so that the resulting string is length characters.

LPAD is an embedded services system function.

To activate and invoke embedded services functions, see Embedded Services System Functions.

• LPAD Function Syntax
• LPAD Argument Types and Rules
• LPAD Result Type
• LPAD Function Examples

ANSI Compliance

This statement is a Teradata extension to the ANSI SQL:2011 standard.