David,

Is it possible the someval <> 0 because it's very small, but the division formats the return value and loses decimal precision? Probably this is totally off the wall...

>I wonder if the SQL engine is getting an untrapped divide by zero? What if you used a UDF instead of the iif()?