Cetin,
Thanks for testing.
I had already got to the workaround you suggest but indeed performance did drop as the table doesn't have an index on deleted.
Pascal.
>Pascal,
>YOU'RE RIGHT !!! I could reproduce it if field was of date or datetime datatype.
>It doesn't behave that way in VFP6 or 7.
>I'm afraid you should use old workaround :
>
>select ... from ... where !deleted() and ...
>
>This might make sense to have an index on deleted().
>Cetin