SELECT v_zips set order to 0 && Zero SCAN IF INDEXSEEK(v_zips.zipcode,.F.,"zips","zipcode") replace v_zips.dealerid WITH zips.dealerid IN v_zips ENDIF ENDSCANOR you can even use next code
replace v_zips.dealerid WITH zips.dealerid ; FOR v_zips.zipcode == zips.zipcode IN v_zips...and of course you can add other "FOR" filters if needed as
replace v_zips.dealerid WITH zips.dealerid ; FOR v_zips.zipcode == zips.zipcode AND ; !EMPTY(v_zips.zipcode) IN v_zips && et ceteraAT