Error converting data type varchar to numeric

%3CLINGO-SUB%20id%3D%22lingo-sub-285475%22%20slang%3D%22en-US%22%3EError%20converting%20data%20type%20varchar%20to%20numeric%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-285475%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20have%20below%20part%20of%20Select%20statement%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EIIF(%5BAPQ%5D.%5BMinFlex%5D%20!%3D%200.00%2C%20'MinFlex%3A'%20%26amp%3B%20CONVERT(decimal(8%2C2)%20%2C%20%5BAPQ%5D.%5BMinFlex%5D%20)%20%2C%20'0')%20AS%20OM_COMMENT%2C%20APQ.COMMENT%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EError%20%3AError%20converting%20data%20type%20varchar%20to%20numeric%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20idea%20what%20is%20wrong%20%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-285515%22%20slang%3D%22en-US%22%3ERe%3A%20Error%20converting%20data%20type%20varchar%20to%20numeric%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-285515%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20might%20help%20you%3A%20%3CA%20href%3D%22https%3A%2F%2Fwww.mssqltips.com%2Fsqlservertip%2F4008%2Fhandling-error-converting-data-type-varchar-to-numeric-in-sql-server%2F%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EHandling%20error%20converting%20data%20type%20varchar%20to%20numeric%20in%20SQL%20Server%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New 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
Highlighted