34,594
社区成员
发帖
与我相关
我的任务
分享
------
create table cm
(
.......
[售价] varchar(50),
........
)-----
--
select * from cm where cast([售价] as flaot)>1000
select * from cm
where charindex('-',[售价])>0
or charindex('*',[售价])>0
select * from cm where isnumeric(售价)=1 and cast([售价] as float)>1000