Archives of the TeradataForum
Message Posted: Fri, 11 Sep 2015 @ 16:27:52 GMT
| Subj: || || Re: Case statement with when and like any |
| From: || || Walter, Todd |
The 2620 error says that the data contains data that is not a number. SUM has to convert the data to numeric in order to add them together.
Review the data returned when you don't use SUM to see if everything being returned is indeed a number and does not contain any extraneous
Is SUM the right operation? Adding up telephone numbers doesn't seem likely to provide a valuable result??