Sir, Scanning like the code you have suggested and the code I gave below makes the difference in Speed or performance.

Select mytable
if empty (variable1)
scan for field2 = variable2
Endscan
Else
scan for field1 = variable1
Endscan
Endif

I am asking this just for my knowledge, if yes I will also make changes in my all of codes accordingly.
Regards




>

select mytable
>
>scan for iif(empty(variable1), field2 = variable2, field1 = variable1)
>    * Code here
>endscan
>