|
Syntax
$LPAD(string, n [,pad])
$LPAD()
Required.
string
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.
n
Required. n is the total length of the return value ( 0 <
n <= 255)
pad
Optional. pad evaluates to a single character. The default
is the space character.
top
Example
SELECT $LPAD(COMPANY, 45, '*'), $RPAD(COMPANY,
45, '*') FROM CUSTOMERS WHERE COMPANY='SYSTEMS'
*****Dynamic Information Systems Corporation
Dynamic Information Systems Corporation *****
top
|
