Progress
SQL-92
Guide and Reference
LPAD Function
Pads the character string corresponding to the first argument on the left with the character string corresponding to the third argument. After the padding, the length of the result is length.
SYNTAX
EXAMPLE
This example illustrates two ways to use the LPAD function:
NOTES
- The first argument to the function must be of type CHARACTER. The second argument to the function must be of type INTEGER. The third argument, if specified, must be of type CHARACTER. If the third argument is not specified, the default value is a string of length 1 containing one blank.
- If
L1
is the length of the first argument andL2
is the value of the second argument:- The result is of type CHARACTER.
- If the argument expression evaluates to null, the result is null.
- The
char_expression
andpad_expression
may contain multi-byte characters. Thelength
specifies a number of characters.COMPATIBILITY
Progress Extension
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |