Conversion of a varchar2 to a number

I have a user that has a phone number field that is stored as a varchar2 and some of the data actually has letters in it. When he tries to do a TO_NUMBER it fails of course on the records that have letters in them.

To perform the conversion I thought using a cursor and handling the exceptions would work, but wanted to see if other people had a better way of doing this.

Thanks, Dave Turner Received on Wed Dec 13 2000 - 12:44:25 CST