IBM Mainframe Forum

Can we use SUM function on Alphanumeric column in db2?

TITLE EDITED.

using an intelligent title will make people more interested in the questions You might ask
a stupid title will usually make people skip the post!

Hello,

I suspect a bit of redesign is in order. . .

If the column can contain any non-numeric value(s), it won't sum.

If it can only contain numeric values, it should be defined as numeric