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 v_QuickSearch ; 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 cTempResultBut now I want to be able to use variable instead of v_QuickSearch, e.g. it could be v_QuickSearch or v_QuickSearch_PolicyNumber or v_QuickSearch_Medicaid. Would you please help me to constract such a statement? Do you think, it's better to build the whole lcSQL as a variable?