Posted by Mac on 09/29/05 17:29

I have imported some data to sql2k from my old system. Somehow, it imported
invoice amount to char type.

I just created another column called invamt2 type NUMERIC so I can copy or
convert content of invamt which is type CHAR. There are about 50,000
records.

How can I convert/cast from char type to numeric type ?

Thanks

[Back to original message]