新人求解解决方法

新人求解
一个视图:

SELECT   *,   CAST(TatolMark   AS   float)   /   CAST(MarkTimes   AS   float)   AS   Mark
FROM   Artis   s  

当MarkTimes   为0的时候,会报错,如何避免




[解决办法]
SELECT *, CAST(TatolMark AS float) / case when CAST(MarkTimes AS float)=0 then null else CAST(MarkTimes AS float) end AS Mark
FROM Artis s