>>Another thing occurred to me. What about using SEEK() instead of IN()
>>
>>SELECT fields FROM helthins_view ;
>>WHERE NOT SEEK(ssno,'helth_priors_tmp',Tag) ;
>> AND NOT SEEK(ssno,'helth_currents_tmp',Tag)
>>
>>
>>Might that even be faster?
>>
>>HTW
>>
>>Matt
>
>Matt, I remember MS recommendation not to use functions which switch work areas inside Select-SQL commands (it really can invoke GPF error).


Yeah, I think I spoke about that earlier today, but I thought that only applied to UDFs. I was under the impression that the Fox Functions were ok. Does SEEK actually change the work area? That might be a stupid question, I'm just not sure.

Matt