求一个数据转换办法

[shan__le]

select Services from dbo.Contract
查询结果如下
8.844
123.2009
176.7991
423.0
573.0
80.0
13.6422
4.059
18.612
5.0
192.0
165.0
11.589554
2008.49
现在该字段为varchar
我数据最多有null的出现，我想把该字段强制转换成numeric，小数点保留4位，直接数据库无法转换，怎么才能将字段转换过来？

[shan__le]

有没有人回答啊？还是无法解决？

[iihero]

是什么数据库？发帖前看置顶标题了吗？

[oO寒枫Oo]

select cast(Services as float) as Services from dbo.Contract
where isnumeric(Services)=1 and Services not like '%[^0-9]%' and Services is not null

[oO寒枫Oo]

select cast(Services as float) as Services from dbo.Contract
where isnumeric(Services)=1 and (Services not like '%[^0-9]%' or charindex('.',EncDataText)>1 ) and Services is not null