Mark, thanks for the reply.

>>Use a filter in the WHERE clause that can be optimized but returns no mathing records. For example, say I have a Primary Key field named KeyID and only contains positive integer numbers:

SELECT * FROM MyTable WHERE MyTable.KeyID = -1>>

I like it, but it would mean a different WHERE condition for each table. If possible, I would like a more generic solution. Does SQL have the equivalent of .F.? I tried WHERE FALSE, but that did not work. However, WHERE 1=0 did produce an empty cursor, but would SQL have checked every record in this case?

Regards,
Alan