>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.
You could use something like
FLOOR(QueryResult * 100) / 100
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up