LPAD

Teradata Vantageā„¢ SQL Functions, Expressions, and Predicates

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1145-162K

Purpose

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

Syntax



TD_SYSFNLIB.
Name of the database where the function is located.
source_string
A character string or string expression.
If the length of source_string is greater than length, source_string is truncated to length characters.
length
The number of characters in the resulting string.
fill_string
The string of characters used to pad the source_string.
The sequence of characters in fill_string is replicated as necessary.