>The INT() function accepts a numeric argument only.
... on TableA.Field1 = INT(VAL(TableB.Field2))
Also, it'll not be Rushmore optimizable if there's no index on INT(VAL(Field2)) in TableB.
Yes, right; I confused int() with val(). Also, I suspect that when converting to character, it may be easier to control the size of the key, at least in older VFP options.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)