SQL查看小数位数大于两位的

SELECT * FROM
(
SELECT '1.34' AS num
)
tab
where charindex('.',REVERSE(cast(tab.num as varchar(50))))-1>2

posted @ 2016-03-31 19:04  大漠孤烟~  阅读(3337)  评论(1)    收藏  举报