max at the same time of 3 fields

[insea]

Hi people,

I have 3 fields in one table and i would like to have at the some time the max of this fields. Can you help me?
Regards

insea

[stanl]

just a guess, but are you looking at something like


SELECT MAX(f1)+MAX(f2)+MAX(f3) as MaxSum FROM [sometable]...


where I think you need to account for Null values etc....

[insea]

That's exactly what i need.
Thanks a lot.
Regards

insea