>Thanks all for the help - particularly Tamar for writing the paper

You're welcome.

>

>   WHERE PartFile.FileLocked = .T. AND ;
>      PartFile.NeverPurge = .F. AND ;
>      NOT EMPTY(PartFile.Folder_ID) AND ;
>      NOT EMPTY(PartFile.Stru_Amt) AND NOT EMPTY(PartFile.Date_Fund) AND ;
>      NOT EMPTY(PartFile.Date_Closd) AND PartFile.Date_Closd < ldCutOffDate AND ;
>      EMPTY(PartFile.Archv_Date) AND PartFile.Archv_Type # "P" AND ;
>      NOT ( Plaintif.EstateFile = .T. AND EMPTY(Plaintif.EstateClsd) ) AND ;
>

For logical fields, I'm partial to just using the field name (for .T.) or NOT the fieldname (for .F.). That's true for me everywhere, not just in SQL. While there's no speed difference, I find I'm really likely to misread (logicalfield = .F.) and I'll never misread (NOT logicalfield). I also feel strongly about using NOT rather than !, because it's too easy to miss the exclamation point.

Tamar