>Hi all,
>
>after I success in a defecult select statement I found that some numbers are getting rounded, while I do need the exact result without rounding it I have a three (3) decimal places in my value but why it is getting rounded I do not know any idea ?
Fox is measuring the size of the columns to create based on the first record(s) it encounters, so if it gets something that doesn't have decimals (or has them but they are zero), it doesn't include them. The old trick which worked as early as FP2.0 was to add a neatly formatted zero, with sufficient number of digits:
select nMyDecimalField+0000000000.000 as nMyField ...
The same goes for trimmed strings - you should use pad*() functions to give the resulting string the width you want.