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 ? 

1 Reply

  • Mark Dommisse's avatar
    Mark Dommisse
    Brass Contributor
    Nov 12, 2018

    This might help you: https://www.mssqltips.com/sqlservertip/4008/handling-error-converting-data-type-varchar-to-numeric-in-sql-server/

Resources