>can you create a cursor with an alias so that use can refer to itby an alias name like: "sele thisalias"
Timothy,

The name you give a cursor is its alias;

CREATE CURSOR MyCursor ...

will create a temporary table on disk named something like C:\temp\1283456.dbf and open it with the alias MyCursor.

SELECT Blah FROM Blah, BlahA WHERE whatever INTO CURSOR MyResult

will create a temporary table on disk named something like C:\temp\1283456.dbf and open it with the alias MyResult.