Posted by Tibor Karaszi on 09/29/05 17:34

If you don't have any dirty data, you can do:

UPDATE tblname
SET invamt2 = CAST(invamt AS numeric(..., ...))

If you do have dirty data, you will get a datatype conversion error from above and need to clean
your data first.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/


"Mac" <mac@hotmail.com> wrote in message news:TSS_e.10727$WT3.7999@trnddc03...
>
> 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: Re: How to convert from CHAR to Numeric in the table
• Prev in forum: Re: How to convert from CHAR to Numeric in the table
• Thread view: Re: How to convert from CHAR to Numeric in the table

[Reply to this message]