SQL语言的一个问题

[woshilh]

select a/b as c
from db

b有可能为零，怎样解决这个问题

[htl258_Tony]

select case b when 0 then 0 else a/b end as c
from db

[woshilh]

回复好快，真是个夜猫子

[sgtzzc]

select CASE WHEN B!=0 THEN a/b END as c
from db