Article View: comp.databases.ms-sqlserver
Article #88How to add 2 columns together
From: Mac
Date: Wed, 06 Apr 2005 22:06
Date: Wed, 06 Apr 2005 22:06
19 lines
1564 bytes
1564 bytes
SQL2K -------- I have 2 columns, one is numeric and 2nd is TEXT or memo column. I have been trying for the last few days with no success. Here is the statement that I have been using: UPDATE MYTABLE SET MYMEMO = STR(PERCENTAGE,7)+' '+MYMEMO When I run it, I get data type error. I would appreciate if someone please help me here. Thx
Technical Details
Message-ID:
<24Z4e.197$Zn3.196@trnddc02>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!newsread.com!news-xfer.newsread.com!news.glorb.com!cyclone1.gnilink.net!spamkiller.gnilink.net!gnilink.net!trnddc02.POSTED!53ab2750!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Thread: 104de1,f7a7324b2be0bec6,start X-Google-Thread: ff490,f7a7324b2be0bec6,start X-Google-Thread: 1131f0,f7a7324b2be0bec6,start X-Google-Thread: 10f695,f7a7324b2be0bec6,start X-Google-Attributes: gid104de1,gidff490,gid1131f0,gid10f695,public X-Google-Language: ENGLISH,ASCII-7-bit Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!newsread.com!news-xfer.newsread.com!news.glorb.com!cyclone1.gnilink.net!spamkiller.gnilink.net!gnilink.net!trnddc02.POSTED!53ab2750!not-for-mail From: "Mac" <mac@hotmail.com> Newsgroups: comp.databases.ms-sqlserver,comp.lang.visual.basic.misc,cz.comp.microsoft.sql,microsoft.public.access.modulesdaovba,microsoft.public.sqlserver.server Subject: How to add 2 columns together Lines: 21 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2180 X-RFC2646: Format=Flowed; Original X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 Message-ID: <24Z4e.197$Zn3.196@trnddc02> Date: Wed, 06 Apr 2005 22:06:54 GMT NNTP-Posting-Host: 66.13.113.18 X-Complaints-To: abuse@verizon.net X-Trace: trnddc02 1112825214 66.13.113.18 (Wed, 06 Apr 2005 18:06:54 EDT) NNTP-Posting-Date: Wed, 06 Apr 2005 18:06:54 EDT