34,590
社区成员
发帖
与我相关
我的任务
分享
select * from 表名 where cast(字段 as numeric(8,2))>13
我感觉这要更简单
select * from table where col>convert(varchar(10),13)
select *
from 表名
where cast(字段 as numeric(8,2))>13
select * from 表名 where cast(字段 as numeric(8,2))>13
declare @tb table (s varchar(10))
insert into @tb select '10.23'
insert into @tb select '11.50'
insert into @tb select '15.00'
select * from @tb where cast(s as decimal(4,2))>13.00