Hi Malcolm,

It's hard to tell which query would be faster w/o running tests that why I sugested the alterenatives. Is difference significant enough to prefer correlated subquery over two others?

>
>I added some additional logic to my sql select and found that your correlated sub-query is starting to perform much better than my original query.
>
>Thanks (again!) for your help - very much appreciated!
>
>
>
>

>* your correlated subquery suggestion that I'm using
>select curWord.cWord from curWord ;
>	where NOT EXISTS ( select * from curDictionary ;
>				WHERE curDictionary.cWord = curWord.cWord ) ;
>	into cursor curMisspelled
>