>I tried to change my line, but since I already had received a feedback, I could not update.
Sorry about that :)
>This was ment to be my second try:
>select 1000000.000*iif(a.split_in="Y",a.price*a.catchweight,0)as T
Why do you want an answer that is 1000000 times too large, when it is not necessary?
>VFP tries to guess the width of the field, and if the first record is 0, then the width will not be big enough.
>
It not really a "guess"; it uses the width of the first record. "Guess" would imply that we have no control over the situation. No big deal, though.
Steve Gibson