How to convert from CHAR to Numeric in the table

Article View: comp.databases.ms-sqlserver

Article #77

Back to comp.databases.ms-sqlserver Previous Next

#77

From: Mac
Date: Thu, 29 Sep 2005 14:29

11 lines
1436 bytes

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

Technical Details

Message-ID: <TSS_e.10727$WT3.7999@trnddc03>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!cyclone1.gnilink.net!spamkiller.gnilink.net!gnilink.net!trnddc03.POSTED!53ab2750!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 104de1,7a42fe3b69ba55f5,start
X-Google-Thread: ff490,7a42fe3b69ba55f5,start
X-Google-Thread: 10f695,7a42fe3b69ba55f5,start
X-Google-Attributes: gid104de1,gidff490,gid10f695,public
X-Google-Language: ENGLISH,ASCII-7-bit
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!cyclone1.gnilink.net!spamkiller.gnilink.net!gnilink.net!trnddc03.POSTED!53ab2750!not-for-mail
From: "Mac" <mac@hotmail.com>
Newsgroups: comp.databases.ms-sqlserver,cz.comp.microsoft.sql,microsoft.public.sqlserver.server
Subject: How to convert from CHAR to Numeric in the table
Lines: 13
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
Message-ID: <TSS_e.10727$WT3.7999@trnddc03>
Date: Thu, 29 Sep 2005 14:29:07 GMT
NNTP-Posting-Host: 66.13.113.18
X-Complaints-To: abuse@verizon.net
X-Trace: trnddc03 1128004147 66.13.113.18 (Thu, 29 Sep 2005 10:29:07 EDT)
NNTP-Posting-Date: Thu, 29 Sep 2005 10:29:07 EDT