Omnidex SQL Function: $LPAD

The $LPAD function adds pad characters to the left of a character string up to the specified total length.

The return data type is C STRING of length specified in the n parameter + 1.

$LPAD( <column_spec | 'string'> , return_length [ ,pad_character ] )

Required. The string to be “padded”. If the length of the string is longer than n, the portion of the string that fits into n is returned.

Required. n is the total length of the return value ( 0 < n ⇐ 255)

Optional. pad evaluates to a single character. The default is the space character.

SELECT 
$LPAD(COMPANY, 45, '*'), 
$RPAD(COMPANY, 45, '#') 
FROM CUSTOMERS 
WHERE COMPANY='SYSTEMS'
 
*****Dynamic Information Systems Corporation
Dynamic Information Systems Corporation #####