>This is good
>SELECT *, .T. AS cFlag FROM hold WHERE !DELETED() INTO CURSOR tmpHold1
>?????????????
>But I want compare a field in the same select
>
>SELECT *, .T. AS cFlag FROM hold WHERE hold.data_prod >= &lcDate1;
> AND hold.data_prod <= &lcDate2;
> and !DELETED() INTO CURSOR tmpHold

I am not sure of your question. The second sql statement looks find. Why are you using "&lcdate1" and not just "lcDate1" (same for the second date).