On 12 Apr 2006 at 18:37, Gerson Machado wrote:

> and ... need multiply Field1 by Field2 and the result truncate in a
> Field3 (Numeric(4,3)), but in stored procedure I receive the error:
>
> Aritmetic overflow, .... numeric overflow...
>
> What I need todo ?

You must learn that numeric(4,3) means only one digit left from
decimal point. If yor result is bigger than 9, you'll get "numeric
overflow" for sure.

--
SY, Dimitry Sibiryakov.