I have a code
select CONVERT(NUMERIC, CASE ISNULL(FLEXFIELD4,'') WHEN '' THEN 0 ELSE FLEXFIELD4 END ) FROM DEIT_INDENT_DTL_INBOUND_RXL WHERE IND_INDENT_NO='NEE15SR000003'
which is giving me error
"Conversion failed when converting the nvarchar value '0.000000' to data type int."
i am unable to find the solution.
Thank you in Advance.