Hi David,

A quick follow up on my previous message. I tested this with xBase and SQL, and it's indeed the difference:

optimizable are:

SELECT COUNT(*) FROM Table WHERE Field = "..."
COUNT TO nCount FOR Field = "..."
COUNT TO nCount FOR "..." = Field

not optimizable is:

SELECT COUNT(*) FROM Table WHERE "..." = Field


Christof