Forum Discussion

Samer Baskhayroun's avatar
Samer Baskhayroun
Copper Contributor
Nov 12, 2018

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 ? 

Resources