Select Sum(FieldName) From TableName Into Cursor CursorName

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