SET CONCAT_NULL_YIELDS_NULL OFF
SELECT (column1 + column2) AS SumOf2Columns FROM yourTable
SET CONCAT_NULL_YIELDS_NULL ON


>>> "Tshepiso Modise " <mssqldba-ezmlmshield-x4650904.[Email address protected] 8/29/2007 1:21:37 AM >>>

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
MS Sql Server LazyDBA home page