>Hi Nadya, why this complexity ?
>if you rename to a static name the dynamic name the query is more readable.
>
>

>lcQS = "v_QuickSearch"
>SELECT v_QuickSearch.*,;
>       IIF (EMPTY(v_QuickSearch.cResolution_Codes_Fk) OR ISNULL (v_QuickSearch.cResolution_Codes_Fk),;
>       v_QuickSearch.cStatus_Codes_Fk,;
>       v_QuickSearch.cResolution_Codes_Fk) AS cVisCodes_Fk,;
>       Employee_queue_schedules.cemployee_queue_schedules_pk,;
>       USERS.cUserID;
>   FROM (m.lcQS) AS v_QuickSearch; && or macro or [varstring] or TEXT TO
>   INNER JOIN mmVisCollect!Trans_employees_queues;
>      ON v_QuickSearch.cTrans_PK = Trans_employees_queues.ctrans_fk;
>   INNER JOIN mmVisCollect!usgrlink;
>      ON Trans_employees_queues.ccommission_owner_usgrlink_fk = usgrlink.cusgrlink_pk;
>   INNER JOIN mmVisCollect!Employee_queue_schedules;
>      ON Trans_employees_queues.ctrans_employees_queues_pk = Employee_queue_schedules.ctrans_employees_queues_fk;
>   INNER JOIN mmVisCollect!USERS;
>      ON  USERS.iid = usgrlink.iuserid;
>   WHERE Trans_employees_queues.iactive_flag = 1;
>      AND Employee_queue_schedules.iactive_flag = 1;
>   INTO CURSOR cTempResult
>

>
>Fabio

Hi Fabio,

Thanks. That was Hugo's suggestion and I re-coded it already to use this form. You're right, in this particular case no need for complexity.