Home » SQL & PL/SQL » SQL & PL/SQL » white
white [message #36587] Wed, 05 December 2001 10:10 Go to next message
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 Go to previous message
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

----------------------------------------------------------------------
Previous Topic: insert data of a file in different variable
Next Topic: datatype for time
Goto Forum:
  


Current Time: Fri Mar 29 02:37:45 CDT 2024