second case Error converting data type varchar to numeric

Question

The values are stored in varchar.I try to check if the values are numeric then convert to decimal, if not then return the original value. The first case itself work fine if I comment out the second part.

CASE WHEN ISNUMERIC(Num) = 1 THEN CONVERT(DECIMAL(7,2),CONVERT(FLOAT, Num))
     WHEN ISNUMERIC(Num) = 0 THEN Num END,

The result of that CASE expression can be different data types, that can't be — Lamak
– Lamak, Commented May 13, 2015 at 17:42

Tim3880 · Accepted Answer · 2015-05-13 17:43:29Z

1

The problem is that you are returning different types. You need convert the return values to the same type for safe query. Either convert the decimal back to varchar, or return 0 when num is not a number.

answered May 13, 2015 at 17:43

Tim3880

2,5831 gold badge13 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

second case Error converting data type varchar to numeric

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related