>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.

DO CASE
CASE _TALLY = 0
  * Query returned 0 record
  lcStatus = "UNKNOWN"
CASE _TALLY > 1
  * Query returned >1  record
  lcStatus = "MULTIPLE STATUSES RETURNED"
OTHERWISE
  lcStatus = aDups[1]
ENDCASE