Subject Select problem --- numeric (13,4) field ---
Author Sandor Szollosi
Hi folks,

I have a table with a NUMERIC(13,4) field,
and a simple query:

SELECT PRICE*PRICE*PRICE*PRICE FROM MY_TABLE

This SQL gets an error:
"Integer overflow. The result of an integer operation caused the most
significant bit of the result to carry."

But this works well:
SELECT PRICE*PRICE*PRICE FROM MY_TABLE

(PRICE=100 now, and one record exists in the table)
Do you know this problem?

Sandor