SELECT SUM(value) AS sum_value FROM mytable ;
  GROUP BY ordnum ;
  INTO CURSOR crsTotal

>I'd like to know if I can use a SQL command to accomplish the same thing that would result for a command like:
>
>TOTAL FIELD value ON ordnum TO tempfile.
>
>Any suggestions?
>
>Thanks,