Jason,
You can run one more select from oracle view to format numerich fields the way you want using STR() function.
>Sergey, I have my program set to access local vfp tables, vfp tables through remote views and oracle tables through remote views.
>
>All 3 are setup identically but when looking at the result from copy to filename type sdf it is only the oracle remote view that has this behavious. None of the local table, local view or remote view to vfp table exhibits this behaviour.
>
>How can I get around this?
>
>Jason
>
>>Jason,
>>
>>In VFP table numeric data internaly is stored as a character string. Because of that VFP adds one position for a sign and one for decimal separator.
>>
--sb--