By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,101 Members | 1,416 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,101 IT Pros & Developers. It's quick & easy.

How to convert from CHAR to Numeric in the table

P: n/a
Mac

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
Sep 29 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
If the only problem is the column data type, and you know the data
itself is already numeric, then you can just alter the column data type
directly:

alter table SomeTable alter column invamt numeric(10,5)

See "CAST and CONVERT" in Books Online for general information about
data type conversion.

Simon

Sep 29 '05 #2

P: n/a
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" <ma*@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


Sep 29 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.