>>Don't specify alias if you want VFP to check every record.
APPEND FROM utemp For (SubStr(Submitter,1,1)="E")
>>
>>>SELECT estate
>>>zap
>>>APPEND FROM utemp For (SubStr(utemp.Submitter,1,1)="E")
>>>go bottom
>>>wait window estate.submitter
>>>
>>>Why would I get all records from UTEMP? I specified 'E' as first letter of first field!
>>>
>>>TIA
>
>So -
>.snip from Jim Nelson.
>APPEND FROM Source FOR Source.lArchive
>the lArchive field is evaluated only for the current record of the source, not for each one in turn. So either all records or no records are copied.
>.endsnip.
>- the inclusion of a Source acts as 'constant logical' for the entire dataset based on the current record...
>I don't know that I would ever need that!
>
But don't overlook the extracted portion above you snipped piece - that the field has to be in the output.
cheers
>thanx to all