>Hi Jim,
>
>Does the IN clause cause any overhead ? Or we should use it regardless?
>Your view please..
>

Kam,

I don't know about overhead for the in clause. I use it when I need it, usually I select the work are I want immediately before tacking any action. I also restore the work area when I am done. For example;

* Save the current work area
LOCAL lcAlias
lcAlias = ALIAS()

*Select the work area to be affected
SELECT Whatever

* Do whatever the plan is
Do Something

* Now restore the work area
IF NOT EMPTY(lcAlias)
  SELECT (lcAlias)
ELSE
  SELECT 0
ENDIF
RETURN

This allows me to call this code from antwhere without being concerned if the work area is being changed.