Skip to Content
0
Former Member
Aug 10, 2007 at 07:03 AM

Can I summurize data whose data type is CURR?

120 Views

Hi guys,

please give me some hint on this problem:

I use SQL Statement

SELECT SUM(f1)

...

the data type of f1 is CURR17, but the result I got is 0. Is it possible to do sum when the data type is CURR17. I read the document, it says SUM can be done when data type is numeric, from my opinion, CURR17 belongs to numeric.

I can not figure out the problem.

Thanks for any hint.

Regards,

Liying