Is there some reason you have not replied to my posting on this thread?

The solution you accepted is not the ideal.

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