>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.