I have a query that will have a result of one column that has 5 decimal places.
When I append that record to a dbf table which has 2 decimal places, it will automatically round it in 2 decimal places.
e.g.
query result is 0.78999
when i append this to my table the result will be 0.79
i dont want that to happen, what i want is 0.78

i know you can convert this to string and do the manipulation there. is there any way to go around with it.

thanks.