SqlServer中如何字符形式如何比较大小
建表语句
---
CREATE
TABLE Terminal_Monitor_Data
(
PK_CODE VARCHAR(50) COLLATE Chinese_PRC_CI_AS NOT NULL,
DeviceId VARCHAR(50) COLLATE Chinese_PRC_CI_AS,
SurveyDate DATETIME,
BloodPressureUp VARCHAR(50) COLLATE Chinese_PRC_CI_AS,
BloodPressureDown VARCHAR(50) COLLATE Chinese_PRC_CI_AS,
PLUS VARCHAR(50) COLLATE Chinese_PRC_CI_AS,
HeartRate VARCHAR(50) COLLATE Chinese_PRC_CI_AS,
CONSTRAINT PK_TERMINAL_MONITOR_DATA PRIMARY KEY (PK_CODE)
)
---


我用了这个语句
select * from Terminal_Monitor_Data where cast(PLUS as float) > 15

报错 将数据类型 varchar 转换为 float 时出错


求解.....


[解决办法]
select * from Terminal_Monitor_Data where rtrim(PLUS)*1.0 > 15

确保plus全是数字
[解决办法]
select * from Terminal_Monitor_Data
where case when isnumeric
(plus)=1 then cast(PLUS as float) else 0 end> 15