Mike,
>>Did you test the two lines I used to illustrate the problem?
>
>Yeah, anyway, the only difference is, I picked a higher number than Craig because he said that the numeric field was 15 and 2 in length...
That's not the *only* difference. :-) My point was that subtracting from 10^16 would fail by ignoring differences in amount due from 1 cent all the way up to several dollars.
>A smaller number can defintally be used.
A smaller number *must* be used.