Hi,

In this case, you would define numeric(38,25).

This will allow the same 13 digits before the decimal point and 25 after, which is the maximum if you need 13 digits before the decimal point, as the overall maximum is 38.

Hope this helps.

Pete

Peter Carter http://sqlserverdownanddirty.blogspot.com/