34,837
社区成员




cast convert 都可以
declare @table table(yali varchar(10))
insert into @table
select '100'
union
select '12.8'
union
select '12'
union
select '11.5'
union
select '56'
union
select '48'
select * from @table
where cast(yali as float)>50.00
select * from @table
where cast(yali as float)>50.00
or cast(yali as float)<12.00