David,
The examples in the Help for SELECT-SQL are quite comprehensive. You will be able to see how each of the different clauses like NOFILTER work. Although I must admit I had to get the 'USE AGAIN' to get a read-write cursor from UT when I did my first VFP3 project. We just post it again every week or so for the next person :-)

>Boy is that arcane! Does this have to do with the optimzer? Is there someplace this behavior is specified? Is this a VFP idiosyncrasy or a standard "SQL" feature? Amazing!
>
>Thanks for your help. I doubt if I'd have ever figured that one out by experimentation.
>
>I find MS's specification of the use of cursors sketchy at best yet they seem like really useful things. Know of any good, comprehensive discussion of the use of cursors with VFP?