Error converting data type varchar to numeric

Copper Contributor

 

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 ? 

1 Reply