I have a field whose values(Numbers) are being represented as Text and number(some as number and some as Text). I want them to be represented as number as I have to compare with the same field in other table. I tried NUM and NUM# in the script, but as there are millions of records, the conversion is taking too long (around 2 hrs). So is there any faster way to do the conversion?
