Could it be related to signing? After all if you inverse your 111.11 entry to
-111.11 I could see a problem with N(5.2)
>>I Just discovered that it's not only this field but every Numeric if stretched to its limits. A N(5.2) will trigger the error when 111.11 is in the field. I still don't know why this is, so any help is stil appreciated.
>
>I don't know if its a "bug" or a "feature" but the numeric field's width must be at least one digit more than the width of the largest numeric value to be stored.
>
>HTH,
>Mike
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05