怎么将字符串转换成numeric

如何将字符串转换成numeric例如:如何将2343.13转换成2343.13[解决办法]cast(col as numeric(12,2))orcon

如何将字符串转换成numeric
例如:如何将'2343.13'转换成2343.13

[解决办法]
cast(col as numeric(12,2))

or

convert
[解决办法]

SQL code

select convert(numeric(10,2),'2343.13')
[解决办法]
SQL codeselect cast('2343.13' as numeric(8,2)) n1,convert(numeric(8,2),'2343.13') n2n1                                      n2--------------------------------------- ---------------------------------------2343.13                                 2343.13(1 row(s) affected)