Please help: SELECT with calc

I have a few columns in a table (DAY_1, DAY_2...DAY_14). I want to sum all of these columns accross all of the records. i.e. what is the total of all numbers in all DAY_x fields for a given WHERE criteria. It should be pretty simple but I can't figure it out.

I tried following but both gave different and wrong results.

(assuming columns are DAY_1, DAY_2 and DAY_3)

SELECT (DAY_1 + DAY_2 + DAY_3) from xxx.yyy where ...

AND SELECT (((DAY_1) + DAY_2) + DAY_3) from ... where ...

Thanks very much for your help!!!

Regards,
Nasir (nnoor_at_cris.com) Received on Fri Oct 31 1997 - 00:00:00 CST