SELECT COUNT(RZSTOP.rte_no) ; && RZSTOP's pk INTO ARRAY countRZSTOP; FROM csrInterim ; LEFT OUTER JOIN mclmpser!RZSTOP ; ON csrInterim.rte_no == RZSTOP.rte_no ; AND csrInterim.rte_let == RZSTOP.rte_let ; AND csrInterim.directn == RZSTOP.directn ; AND csrInterim.seqno == RZSTOP.seqno ; WHERE csrInterim.rte_no == lcRteNo ; AND csrInterim.rte_let == lcRteLet ; AND csrInterim.directn == lcDirectn ; AND csrInterim.var_code == lcVarCode ; AND csrInterim.SeqNo == lnSeqNo ; NOCONSOLE && 18/04/05 23/12/04 - this should do for just 1 sequence of a var