Removing ',' in values? [message #334412] |
Wed, 16 July 2008 07:21  |
tondapi
Messages: 99 Registered: August 2007 Location: usa
|
Member |
|
|
Hi,
In My database i have year colummn.It showing values like
2,006
2,007
2,008....
But i want to remove ',' in year.How can i remove that one.Can any one help me.
|
|
|
|
|
Re: Removing ',' in values? [message #334421 is a reply to message #334412] |
Wed, 16 July 2008 07:38  |
Frank
Messages: 7901 Registered: March 2000
|
Senior Member |
|
|
tondapi wrote on Wed, 16 July 2008 14:21 | Hi,
In My database i have year colummn.It showing values like
2,006
2,007
2,008....
But i want to remove ',' in year.How can i remove that one.Can any one help me.
|
Are you sure?
Are those stored in varchar2 columns or do you just use some default formatting on output of numbers?
do a DESC on that table to see what the datatype of the column is.
|
|
|