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 often as required until the character string has reached the 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.

	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 the NULL value	Error message

Examples

SQL Tutorial, Changing Character Strings

 

See also:

RFILL(x,a,n)

EXPAND(x,n)