slq中字符转为数字: cast(字段 as 数值类型) -2 from gads select sgreads=cast(sgreads as decimal)-2 from gads where sid=1