lcOldNear = set("near") set near off && see if the setting for NEAR is ON. if so turn it off. select 0 use Scanfile select 0 use Ecu &&dump from sql index on alltrim(label) to z select Scanfile && new line of code locate do while .not. eof("Scanfile") lab = allt(data) select Ecu seek lab if .not. eof("Ecu") replace scanfile.acct with acct && ok here else replace scanfile.noun with 'UNKNOWN' && NEVER happens, remains blank endif select Scanfile skip enddo select Scanfile set filter to noun = ' ' browse select Scanfile replace all noun with 'UNKNOWN' set filter to browse && ALIAS NOT FOUND! set near &lcOldNear