>you can do an on error
>or
>check the denominator before the division and if denominator == 0 do code.

Thanks for your help everyone. I ended up using our Divide() function which handles divide by zero. I prefer not to use UDFs in local views, but in this case it was the easiest thing to do. We'll see how SQL Server handles the issue when I upsize.