Not sure if this is accurate, but perhaps it helps:

==============================
SELECT (SUM(column1) + SUM(column2)) AS Col1And2 FROM TableName
=============================

-----Original Message-----
From: Tshepiso Modise
[mailto:mssqldba-ezmlmshield-x4650904.[Email address protected]
Sent: Wednesday, August 29, 2007 10:22 AM
To: LazyDBA Discussion
Subject: Hi all

Hi all I have a setback here please help, I am trying to add value's on
two columns together of one table. how do I do this?



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


------------------------------------------------------------------------------------------
This e-mail was checked by the Verizon Business Internet Mail Content Filtering Service.

The I M C F provides you with upstream anti-spam and content filtering and multi layered virus protection.

For more information please contact your Verizon Business account manager or the sender of this e-mail!!
------------------------------------------------------------------------------------------


MS Sql Server LazyDBA home page