Hibernate version:3.2.RC4

MySQL 5

Hi, I have one tricky problem, MySQL table Polloftheday has next fields,
answer1_num (integer), answer2_num(integer), answer3_num(integer) and
answer4_num (integer).

Poll can have minimum two questions and max. four questions.

I want to add these fields like answer1_num, answer2_num, etc. to get total votes.

Problem is that some of these fields can be null and I am for math function
answer1_num+answer2_num+answer3_num+answer4_num getting null if any of fields is null. Later I want to sort by that calculated colum but that would be my next question.

i would do this "math" in Java -- it is easy enough to iterate and test for null or you may try to use the SQL directly.