>When you append into a table with an n(7,2) field from a text file containing numbers without decimal points, you should get the following:
>0001234 -> 1234.00
>0012345 -> 12345.0
>0123456 -> 123456
>1234567 -> 1234567
>
>But one time recently, I got
>0001234 -> 12.34
>0012345 -> 123.45
>0123456 -> 1234.56
>1234567 -> 12345.6
>I have not been able to reproduce this one-time result. Any idea of how to get it, so I can be sure to avoid it?
>
>-Dave Scott
Dave,
The problem is that the N(7,2) means that you are using a total of 7 places which incudes 1 for the decimal point. So the max number you can import for a N(7,2) field would be 9999.99.
HTH
//:^)