>Hi Matt,
>
>Functions without alias refer to the main table of the query (or an arbitrary one, if there are multiple tables involved). You would need to pass the alias name to DELETED(), which is impossible, as VFP uses random aliases within a SELECT statement. DELETED("csrTempJobItems") would not refer to the table on which the query is performed and would therefore return the same value for every record.

Thanks to you all. At least you have confirmed that I am not crazy and the result I got was common.

Now I know how to work around this.

VFP community is the best!