LFILL(x,a,n)

LFILL(x,a,n) is a string function that inserts the character string a (string literal) at the start of the character string x (string specification) as many times as necessary until the character string has reached length n (unsigned integer). Only expressions that produce an alphanumeric value are permitted as string specifications.

If the character string a cannot be completely inserted without exceeding the specified total length, only the part that is needed to reach the total length is inserted.

LFILL(x,a,n)
x, a, n	Result of the LFILL(x,a,n) Function
`LFILL(x,a)`, `x` must identify a `CHAR` or `VARCHAR` column	The column `x` is filled with the characters of `a` until its maximum length is reached
`x` is a NULL value	`NULL` value
`a` or `n` is a `NULL` value	Error message

Example

SQL Tutorial, Changing Character Strings

More Information

RFILL(x,a,n)

EXPAND(x,n)