>>For example, the following code works:
>>select * from tblgl order by tblgl.tempgl into cursor test
>>The code below does not work:
>>ctemp = "tblgl.tempgl"
>>select * from tblgl order by (ctemp) into cursor test
>>Is there a way to use a memory variable in a SQL Select statement?
>
>Try :
>
>select * from tblgl order by &ctemp into cursor test
>
>that should work for you.

Yea that works. For some reason I thought I tried that already . . . Oh well, thanks for the answer - it works.