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

LPAD ( char_expression , length [ , pad_expression ] ) 

EXAMPLE

This example illustrates two ways to use the LPAD function:

SELECT LPAD (last_name, 30) FROM customer ;   
 
SELECT LPAD (last_name, 30, ’.’) FROM customer ; 

NOTES

COMPATIBILITY

Progress Extension


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095