Re: Formating/Converting Words to numbers [message #2054] |
Wed, 19 June 2002 06:37 |
Godwin
Messages: 37 Registered: January 2002
|
Member |
|
|
Thanks for that explanation. But what i still want is how to actually remove the trailing "----" from the number_column. I tried this option and it does it i.e
select varchar2_c,substr(number_column,1,5) but the problem again here is how do I know the argument (1,5) to be used in the substr function before i do the formating.?
|
|
|
Re: Formating/Converting Words to numbers [message #2070 is a reply to message #2054] |
Wed, 19 June 2002 16:11 |
Amit Chauhan
Messages: 74 Registered: July 1999
|
Member |
|
|
Hi,
Number column is never stored with space padded. Its just for display purpose that oracle right align it by padding spaces.
You can remove trailing spaces from a string though :
select trim (varchar_column)
from my_table
Hope that helps.
Amit
|
|
|