How can i assign the output from the query to a variable.
from this query i am expecting this out put.(ANR - ACCPTD AS NOTED; RESUBMITTAL REQUIRED)

***********start******************
select optwords from smltbl where ;
opttitle = 'APPR_CD' and ;
optwords like 'oldresponse%' ;
INTO ARRAY aDups

***************End*************

Thank you very much.