Select A + B from (
Select 'A' = case when a.var1 = 9 then 0 else a.var1 END ,
'B' = Case when a.var2 = 9 then 0 else a.var2 END
Open in new window
IT issues often require a personalized solution. With Ask the Experts™, submit your questions to our certified professionals and receive unlimited, customized solutions that work for you.