>>Hi Gang...
>>
>>A colleague here asked me why he was getting a Numeric Overflow on a field of a table. The field was 9,0 9 wide with no decimals.
>>
>>It was displayed as ****** in the field.
>>
>>Don't know what the value was going on.
>>
>>The code that put the value there was...
>>
>>myvalue = val(right(mystring,6))
>>
>>replace myfield with myvalue
>>
>>I tried different combinations for mystring, but could not overflow it...... any ideas what made it overflow on that certain value? Or what the value might be?
>>
>>Thanks!
>
>Something like 9E18, may be?

Yeah... my friend called me over and he showed me the actual value in the field (he had to connect to them and look at the data).... 2011E+10... yikes! Now we have to figure out how that got in there!