Hi, Mike

I was absent from forum and will see your solution.


Moises



>>HI
>>
>>I am not succeeding by using the structure below:
>>Looks like case or if does not match with scan.
>>
>>==========================================================
>>select mytable
>>
>> if empty (variable1)
>>
>> scan for field2 = variable2
>>
>> else
>>
>> scan for field1 = variable1
>>
>> endif
>>
>>
>> endscan
>>===========================================================
>
>

>if empty(variable1)
>  lccmd = "field2 = variable2"
>else
>  lccmd = "field1 = variable1"
>endif
>scan for &lccmd
>

>
>That is the best way to do what you want. The scan command will execute once. There will be no IIF per record waste of processing.