SELECT CAST('002' AS signed) 结果为2

SELECT CAST('125e342.83' as signed) 结果为 125