divide by 0 error

[Bebe]

why is this causing a divide by 0 error???

update #totals
set units_cancel_percent = units_sent/units_cancelled

in my temp table I am trying to divide the results of these two colums by each other in an update statement; how can I do this????

[JHausmann]

Maybe?

update #totals
set units_cancel_percent = units_sent/units_cancelled
where units_cancelled not null and units_cancelled<> 0

[Bebe]

yes, that works