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

• Next in forum: How to convert from CHAR to Numeric in the table
• Prev in forum: How to convert from CHAR to Numeric in the table
• Thread view: How to convert from CHAR to Numeric in the table

[Reply to this message]