>No, not running SET DECIMALS TO 0 ....
>
>I am converting from one DBF with a C(6) field equipcode containing values such as:
>
>2098
>0092
>3100
>2101
>2435
>
>In a SCAN / ENDSCAN ... REPLACE equipment WITH VAL(equipcode), where equipment is N10.0
>
>The results are:
>
>298
>92
>31
>211
>2435
>
>I thought I understood VAL as returning the Value of the character field, but it seems to be dropping all zeros ...
>
>Best,
>
Harold,
Can you run one UPDATE command: (in try/catch block)
update myTable set Equipment = val(EquipCode)
If it's not broken, fix it until it is.
My Blog