Beth,

In SQL Server, the '-' sign doesn't require a separate position for storing so -102365.00 will fit into numeric(6,0)

>I thought it was that one. But I was seeing 7 places which would fit into 8. Thanks for explaining that. The other programmer, who works with this data, says that number should not be negative or that big also.
>
>Thanks for the great help.
>Beth
>
>>You're trying to insert -102365.00 in the column mileag numeric(8,4) which only accept 4 digits before decimal point (9999.9999).