从数据类型 varchar 转换为 numeric 时出错。

Question

INSERT INTO @RetTable
	select r.sickness_id ,s.name AS sickness_name,@pa_id AS pa_id,@group_id AS group_id,r.item_id from itemResult ir
	inner join B_Sickness_Rule r on r.item_id=ir.item_id and r.is_del=0
	inner JOIN dbo.B_Sickness s ON r.sickness_id=s.id AND s.is_del=0
	where 
			(
				ir.result_type=1 
				AND r.rule_type='区间'
				AND cast(isnull(r.rule_low,'0.00') as numeric(20,2))<=CAST(isnull(ir.result ,'0.00') as numeric(20,2))
				AND cast(isnull(r.rule_high,'0.00') as numeric(20,2))>=CAST(isnull(ir.result ,'0.00') as numeric(20,2))
				
				
			);

从数据类型 varchar 转换为 numeric 时出错。大家看看什么问题

Answer 1

从数据类型 varchar 转换为 numeric 时出错，rule_low字段里面的值是不是有非数字字符呢