Are you using an IIF in your numeric field that has a constant as one of the conditions? If so, the constant has to specify the right number of digits before and after the decimal.

>When I do a SELECT into a cursor or to a table it rounds the numeric fields. How can I fix that to return exactly what is?
>I tried to SET DECIAMALS but that did not help. Any suggestions?