>Sergey-
>
>>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.
>
>Since it's are remote view on SQL Server backend, that's pertinent, is it?

No it's not. :)