Shih (or is it Tai?)

Yes, there was a reason - you specified exactly N(9,2), and to assure exactly that the suggestion given is needed.

regards,
Jim N

>It works. Thx.
>
>In fact, I just multiply by 1 at both the SELECT and it works. Any reason for multiplying and dividing the big number. It seems to make the field big.
>
>
>Tai SC
>
>>>I am using FPW26. I am trying to UNION two select statement. The SELECT statement looks like the following:
>>>
>>>SELECT a.doc_no, doc_date, SUM(apply+discount+miscellaneous) AS problem;
>>> from a, b ;
>>> where a,doc=b.doc ;
>>>UNION ;
>>>SELECT a.doc, doc_date, doc_amt ;
>>> from a ;
>>> where .......
>>>
>>>
>>>Anybody can tell me how I can force the SUM() type to be the Numeric size I want. apply is N(9,2). discount is N(7,2), miscellaneous is N(7,2), problem ended up as N(16,2) and my doc_amt is N(9,2). How to force problem to be N(9,2)?
>>>
>>>
>>>Tai SC
>>
>>You are so right this silly behaviour. A silly but working suggestion is here :
>>SELECT a.doc_no, doc_date, SUM(apply+discount+miscellaneous) * 1000000.00/1000000.00 AS problem;
>> from a, b ;
>> where a,doc=b.doc ;
>>UNION ;
>>SELECT a.doc, doc_date, doc_amt* 1000000.00/1000000.00 ;
>> from a ;
>> where .......
>>
>>Cetin