Forum Discussion
Samer Baskhayroun
Nov 12, 2018Copper Contributor
Error converting data type varchar to numeric
i have below part of Select statement
IIF([APQ].[MinFlex] != 0.00, 'MinFlex:' & CONVERT(decimal(8,2) , [APQ].[MinFlex] ) , '0') AS OM_COMMENT, APQ.COMMENT
Error :Error converting data type varchar to numeric
Any idea what is wrong ?
- Mark DommisseBrass Contributor
This might help you: Handling error converting data type varchar to numeric in SQL Server