sql - 将 varchar 值 '71.8' 转换为数据类型 int 时转换失败

Question

我正在尝试转换 varchar(20)字段到 numeric(10,2)为此，我正在使用此脚本:

SELECT CAST(CASE Age WHEN 'NULL' THEN 0 ELSE Age END AS numeric(10,2)) AS Age 
FROM   AgeTable

但我收到此错误:

Conversion failed when converting the varchar value '71.8' to data type int.

Answer 1

基本上与@Mikael Eriksson's solution相同，只有更多的语法糖:

SELECT ISNULL(CAST(NULLIF(Age, 'NULL') AS numeric(10, 2)), 0)
FROM AgeTable