SELECT iif(!empty(localdesc),localdesc,DESCRIPTIO),PADR(dcode,15) AS dcode1 ; FROM ( m.gcProcDBF ) ; where screenoption=[RADIOLOGY] ; UNION ALL ; SELECT procalias, PADR(dcode,15) AS dcode1 ; FROM ( m.gcPAlias ) ; ORDER BY 1 ; INTO ARRAY RADPROCS