Edgar-

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

You can do the select adding 0 (with the maximum number of decimals places) to the numeric field. Something like this:

SELECT 000000000000.000000 + nNumeric FROM cTable