Finding max and sum in a row

[SDas]

yesmein, Try something like:

SELECT ID, Cat1,  Cat2,  Cat3
     , MAX(Cat1,  Cat2,  Cat3) AS MAXVALUE
     ,    (Cat1 + Cat2 + Cat3) AS SUMVALUE