Aggregrate Question

[darude]

Good afternoon,
I have 4 bit fields in a table and I need to sum each so that the result looks like:

Field1 Field2 Field3 Field4
5 10 15 23

My statement looks like:
SELECT Field1, Field2, Field3, Field4
FROM YTFIntakes
WHERE Year(IntakeDate) = '2008' and AcademicIssues = 1

Thank you in advance.

 

[PWise]

try

SELECT sum(convert(int,Field1)), sum(convert(int,Field2)), sum(convert(int,Field3)), sum(convert(int,Field4))
FROM YTFIntakes
WHERE Year(IntakeDate) = '2008' and AcademicIssues = 1