I understand it is correct. The point is it is diffeent. Sometimes it doesn't matter wether it is correct or not. If there is code written in VFP6 it was written with the anticpation that the product would act a certain way. So when you change it you have a problem.

I am in the process of changing my views to read

isnull(gifts.c_id) instead of

Subscribers.c_id <> gifts.c_id.

George pointing out the tool to search the project made finding the 49 instances easy. I am writing code to go through the DBC abd make the changes programatically right now.

Mitch