SELECT ZZ5TaskId, ZZ1ImageFile
FROM RecResult1
WHERE (APrice1 BETWEEN 2000 AND 1150)
可以执行~
SELECT ZZ5TaskId, ZZ1ImageFile
FROM RecResult1
WHERE (APrice1 BETWEEN 2000 AND 1150) OR
(APrice2 BETWEEN 2100 AND 1100) OR
(APrice3 BETWEEN 3400 AND 1210) OR
(APrice4 BETWEEN 4000 AND 1200) OR
(APrice5 BETWEEN 4000 AND 1250) OR
(APrice6 BETWEEN 3200 AND 1100) OR
(BPrice1 BETWEEN 2000 AND 1150) OR
(BPrice2 BETWEEN 2100 AND 1100) OR
(BPrice3 BETWEEN 3400 AND 1210) OR
(BPrice4 BETWEEN 4000 AND 1200) OR
(BPrice5 BETWEEN 4000 AND 1250) OR
(BPrice6 BETWEEN 3200 AND 1100) OR
(CPrice1 BETWEEN 2000 AND 1150) OR
(CPrice2 BETWEEN 2100 AND 1100) OR
(CPrice3 BETWEEN 3400 AND 1210) OR
(CPrice4 BETWEEN 4000 AND 1200)
就报错~将 varchar 值 '320O' 转换为数据类型为 int 的列时发生语法错误。
如何解决!!!
在线等!!!