>The problem shows itself with such a trivial example, I really can't bring myself to believe that it is a fault with the SQL in VfP - it must be something I'm missing, but I just can't see what.

Len - maybe this was in the original message, but can you write code that includes CREATE TABLE statements and INSERT INTO so that we can paste the whole thing into a program and play with it.

Thanks,
Tamar