Originally posted by pepsipaul Where MemberNo NOT IN field
Are you sure NOT IN is what you want? The "code" you posted is not enough for me to distinguish between:
1) Where INSTR(field, MemberNo) = 0 <- where MemberNo and field are from the same row
2) Where MemberNo NOT IN (Select field From . . . )
as possibly correct coding.
Caution: NOT IN behaves non-intuitively (but logically) when the Select returns a NULL. Unless you've cracked that, NOT EXISTS is more likely to give the answer you expect.