>>Hello,
>>
>>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?
>
>see what your set(Decimals) is set to.

When I say SP_COlumns test I get precision = 10, Length = 12, scale = 0.

So I wonder why is the length 12, and how can I enforce it to be 10?