求sql语句判断小数点位数

Question

id    price
1      2.33
2      2.3232
3      2.44
4      2.22
5      2.5334545
...
select * from 表  where   price小数点长度大于2查询price字段小数点位数大于2的数

Answer 1

http://space.itpub.net/16754036/viewspace-708368

Answer 2

where charindex('.',REVERSE(cast(price as varchar(50))))-1>2

Answer 3

select * from 表 where len(cast(price as varchar))-len(cast(cast(price as int) as varchar))>3大于3是因为还有一个小数点

Answer 4

SELECT * FROM TB WHERE PIRCE>CONVERT(DEC(18,2),PIRCE)