data type conversion

Hi All,

We have couple of columns in a table that were created as VARCHAR2. These columns are to hold numbers. Every once in a while our database receives junk data from users and the scripts that does computations are failing since they require numbers.

I want clean up these tables. I want to add a new column and drop the old column. The question is what is best way to move the data from old column to the new. I only want to copy values that are numbers. How should I do this ?
Is it just a update statement ?.

Any help is appreciated.

Thanks a lot

Vissu Received on Tue Sep 10 2002 - 04:30:18 CEST