>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.