Ah, my bad.

Didn't read the question close enough...

In that case,

select CASE field2 WHEN 0 THEN 0

ELSE (field1 / field2) END

+ ( other calcs )

FROM ....

should do just as required..

/Kenneth