大家给我看看这段sql语句为什么不对？

[sxzkf]

下面这段代码测试通不过：

sql="select sum(precipitation) as p from tabtimedata where isnumeric(precipitation)=1 and stationnum =57036 and observtimes between 2006042006 and 2006042012"

但是下面这段时可以的：


sql="select precipitation from tabtimedata where isnumeric(precipitation)=1 and stationnum =57036 and observtimes between 2006042006 and 2006042012"

谢谢

[jinfeng003]

precipitation 字段会不会不是数值类型？

[cqq]

看看错误信息，


sum(Cast(precipitation as int))