VFP stores numeric(N) data type in a table as a string. As result it has to reserve 1 additional position for a sign and one for a decimal point.

Why it's a problem?

>
>I create a table in MsSQL with
>

>CREATE TABLE Test (test Decimal(10,0))
>

>
>When I query from this table
>

>SQLEXEC(1,"SELECT * FROM Test","cuTest")
>

>Then the field Test.test is 12 decimals.
>How can that be, and how can I avoid this inconsistency?