I think I should know this but..........

I have a DB2 table with fields Num1, Num2, Num3 (among others)

I need to get the largest of the three numeric fields.

Clearly SELECT MAX(Num1, Num2, Num3) FROM mytable won't work, but it seems as if there ought to be some simple equivalent. I just haven't been able to find it.

Can somebody point me in the right direction?

Thanks.........Rich