SELECT * FROM
(
SELECT '1.34' AS num
)
tab
where charindex('.',REVERSE(cast(tab.num as varchar(50))))-1>2
转载于:https://www.cnblogs.com/denghuachengle/p/5342372.html
SELECT * FROM
(
SELECT '1.34' AS num
)
tab
where charindex('.',REVERSE(cast(tab.num as varchar(50))))-1>2
转载于:https://www.cnblogs.com/denghuachengle/p/5342372.html