white [message #36587] |
Wed, 05 December 2001 10:10 |
adelia
Messages: 45 Registered: April 2001
|
Member |
|
|
How can I concatenate variables white spaces with a string
Eg : select rpad(name,' ',20-LENGTH(Name))
from names;
----------------------------------------------------------------------
|
|
|
Re: white [message #36590 is a reply to message #36587] |
Wed, 05 December 2001 10:53 |
Todd Barry
Messages: 4819 Registered: August 2001
|
Senior Member |
|
|
If you just want the column right-padded with spaces to a width of 20:
select rpad(name, 20) from names
----------------------------------------------------------------------
|
|
|