FIX: Select Statement Can Cause Arithmetic Overflow

SYMPTOMS

In general, when you use the Select statement and a query that involves the multiplication of a decimal number and the value returned from a function, an Arithmetic Overflow error message appears. This error message also appears in the following three specific conditions:

1. Calculation must involve at least three operands
2. Calculation must include the following three operations:
   
   
   1. an integer constant multiplied by
   2. an integer returned from a function multiplied by
   3. a decimal or numeric value in the form of either a constant, local variable or a column value.
3. Calculation be performed in the order in which they are listed in Condition 2 above.